Sqlcommand. executenonquery Method

Sqlcommand. executenonquery Method

Execute a Transact-SQL statement on the connection and return the affected number of rows, which is an int data type.

Namespace:System. Data. sqlclient
Assembly:System. Data (in system. Data. dll
Medium)

Syntax

C #

public override int ExecuteNonQuery ()

C ++

public:virtual int ExecuteNonQuery () override

J #

public int ExecuteNonQuery ()

JScript

public override function ExecuteNonQuery () : int

Return Value

Number of affected rows.

Exception

Exception type	Condition
Sqlexception	An exception occurred while executing the command on the locked line. If Microsoft. NET Framework 1.0 is used, this exception is not generated.

Remarks

You can useExecutenonqueryTo perform directory operations (such as querying the database structure or creating database objects such as tables), or
Update, insert, or delete statements without using Dataset
To change the data in the database.

AlthoughExecutenonqueryNo rows are returned, but any output parameters or return values mapped to parameters are filled with data.

For update, insert, and delete statements, the returned value is the number of rows affected by the command. For all other types of statements, the return value is-1. If rollback occurs, the returned value is
-1.

Example

The following example creates a sqlcommand and then uses
ExecutenonqueryRun it. In this example, two strings are passed: A string is a Transact-SQL statement (such as update, insert, or
The other string is used to connect to the data source.

C #
Copy code

Private Static void createcommand (string querystring, string connectionstring) {using (sqlconnection connection = new sqlconnection (connectionstring) {sqlcommand command = new
 
 
Sqlcommand (querystring, connection); command. Connection. open (); command. executenonquery ();}
 
}
Encapsulation: