Executes a SQL statement against the connection and returns the number of rows affected.
Namespace:
MySql.Data.MySqlClient
Assembly:
MySql.Data (in MySql.Data.dll) Version: 6.2.2.0
Syntax
C# |
---|
public override int ExecuteNonQuery() |
Visual Basic (Declaration) |
---|
Public Overrides Function ExecuteNonQuery As Integer |
Visual C++ |
---|
public:
virtual int ExecuteNonQuery() override |
Return Value
Number of rows affected
Implements
IDbCommand..::.ExecuteNonQuery()()()
Remarks
Examples
The following example creates a MySqlCommand and then
executes it using ExecuteNonQuery. The example is passed a string that is a
SQL statement (such as UPDATE, INSERT, or DELETE) and a string to use to
connect to the data source.
CopyVB.NET
Public Sub CreateMySqlCommand(myExecuteQuery As String, myConnection As MySqlConnection)
Dim myCommand As New MySqlCommand(myExecuteQuery, myConnection)
myCommand.Connection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
End Sub
CopyC#
public void CreateMySqlCommand(string myExecuteQuery, MySqlConnection myConnection)
{
MySqlCommand myCommand = new MySqlCommand(myExecuteQuery, myConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
See Also