Executes the respective command for each inserted, updated, or deleted row in the DataSet.

Namespace: CodeSmith.Engine
Assembly: CodeSmith.Engine (in CodeSmith.Engine.dll) Version: 6.0.0.0 (7.0.0.15127)

Syntax

C#
public virtual void UpdateDataset(
	IDbCommand insertCommand,
	IDbCommand deleteCommand,
	IDbCommand updateCommand,
	DataSet dataSet,
	string tableName
)
Visual Basic
Public Overridable Sub UpdateDataset ( 
	insertCommand As IDbCommand,
	deleteCommand As IDbCommand,
	updateCommand As IDbCommand,
	dataSet As DataSet,
	tableName As String
)

Parameters

insertCommand
Type: System.Data..::..IDbCommand
A valid SQL statement or stored procedure to insert new records into the data source
deleteCommand
Type: System.Data..::..IDbCommand
A valid SQL statement or stored procedure to delete records from the data source
updateCommand
Type: System.Data..::..IDbCommand
A valid SQL statement or stored procedure used to update records in the data source
dataSet
Type: System.Data..::..DataSet
The DataSet used to update the data source
tableName
Type: System..::..String
The DataTable used to update the data source.

Examples

 Copy imageCopy
helper.UpdateDataset(conn, insertCommand, deleteCommand, updateCommand, dataSet, "Order");

See Also