Executes and ad-hoc SQL statement that does not return a record set.

Namespace:  DbNetLink.Data
Assembly:  DbNetLink.DbNetData (in DbNetLink.DbNetData.dll) Version: 1.0.0.0 (1.0.0.0)

Syntax

C#
public int ExecuteNonQuery(
	string Sql,
	IDictionary Params,
	bool IgnoreErrors
)
Visual Basic (Declaration)
Public Function ExecuteNonQuery ( _
	Sql As String, _
	Params As IDictionary, _
	IgnoreErrors As Boolean _
) As Integer
Visual C++
public:
int ExecuteNonQuery(
	String^ Sql, 
	IDictionary^ Params, 
	bool IgnoreErrors
)

Parameters

Sql
Type: System..::.String

The insert statement or table name

Params
Type: System.Collections..::.IDictionary

Parameter values collection

IgnoreErrors
Type: System..::.Boolean

Suppress any encountered errors

Return Value

Returns the number of rows affected

Examples

CopyC#
DbNetData Db = new DbNetData( ConfigurationManager.ConnectionStrings["nwind"] );
Db.Open();
Db.ExecuteNonQuery("drop table products", null, true)
Db.Close();

See Also