Executes and ad-hoc SQL statement that does not return a record set.
Declaration Syntax| C# | Visual Basic |
public int ExecuteNonQuery( CommandConfig CmdConfig )
Public Function ExecuteNonQuery ( _ CmdConfig As CommandConfig _ ) As Integer
Parameters- CmdConfig (CommandConfig)
-
The SQL statement and parameters
Return Value
Returns the number of rows affected
Examples
CopyC#DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] ); Data.Open(); CommandConfig CmdConfig = new CommandConfig("drop table products"); Data.ExecuteNonQuery(CmdConfig) Data.Close();