VistaDB 5

ExecuteNonQuery Method
Executes a SQL statement against a connection object.
Public Overrides NotOverridable Function ExecuteNonQuery() As System.Integer
Dim instance As VistaDBCommand
Dim value As System.Integer
value = instance.ExecuteNonQuery()
public override ExecuteNonQuery()
public function ExecuteNonQuery(): System.Integer; override; 
public override function ExecuteNonQuery() :;
public: ExecuteNonQuery(); override 
public: ExecuteNonQuery(); override 

Return Value

The number of rows affected.
The following example insert new row with using parameters
public void InsertRow(VistaDBConnection connection, long id_Customer)
	VistaDBCommand command = new VistaDBCommand();
	command.Connection = connection;
	command.CommandText = "INSERT INTO Orders (ID_Customer) VALUES (@ID_Customer)";
	command.Parameters.Add("@ID_Customer", id_Customer);

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also