Executes an SQL update statement

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

Syntax

C#
public long ExecuteUpdate(
	string Sql
)
Visual Basic (Declaration)
Public Function ExecuteUpdate ( _
	Sql As String _
) As Long
Visual C++
public:
long long ExecuteUpdate(
	String^ Sql
)

Parameters

Sql
Type: System..::.String

The SQL update statement

Return Value

Returns the number of rows affected

Examples

CopyC#
DbNetData Db = new DbNetData( ConfigurationManager.ConnectionStrings["nwind"] );
Db.Open();
Db.ExecuteUpdate("update product set productname = '" + ProductName.Value + "' where productid = " + ProductID.Value );
Db.Close();

See Also