SqlClient.ExecuteNonQuery Method

SqlClient ExecuteNonQuery Method

Nemiro.Data.dll

Executes a Transact-SQL statement against the connection and returns the number of rows affected. This method is used in conjunction with the properties CommandType, CommandText and Parameters.

Namespace: Nemiro.Data.Sql
Assembly: Nemiro.Data (in Nemiro.Data.dll) Version: 2.11.4.126 (2.11.4.126)

Syntax

C++

Copy to Clipboard Print

public int ExecuteNonQuery()

public int ExecuteNonQuery()

Public Function ExecuteNonQuery As Integer

Public Function ExecuteNonQuery As Integer

Return Value

Type: Int32

Exceptions

Exception	Condition
SqlException	The exception that is thrown when SQL Server returns a warning or error.
ValueForIdentityException	An exception occurs if the property of primary key has not flag the Identity and field is autoincrement.
StringOrBinaryDataWouldBeTruncatedException	An exception occurs if some of the fields of the table are added values that exceed the allowable size of a table field.

Remarks

Caching options are ignored.

Examples

C++

Copy to Clipboard Print

using (SqlClient client = new SqlClient())
{
  client.CommandText = "UPDATE messages SET hits = hits + 1 WHERE id = 42";
  int used = client.ExecuteNonQuery();
  Console.WriteLine("Updated {0} rows.", used);
}

using (SqlClient client = new SqlClient())
{
  client.CommandText = "UPDATE messages SET hits = hits + 1 WHERE id = 42";
  int used = client.ExecuteNonQuery();
  Console.WriteLine("Updated {0} rows.", used);
}

Using client As New SqlClient()
  client.CommandText = "UPDATE messages SET hits = hits + 1 WHERE id = 42" 
  Dim used As Integer = client.ExecuteNonQuery()
  Console.WriteLine("Updated {0} rows.", used)
End Using

Using client As New SqlClient()
  client.CommandText = "UPDATE messages SET hits = hits + 1 WHERE id = 42" 
  Dim used As Integer = client.ExecuteNonQuery()
  Console.WriteLine("Updated {0} rows.", used)
End Using