Execute an IDbCommand (that returns a resultset and takes no parameters) against the provided IDbTransaction.

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

Syntax

C#
public virtual void FillDataset(
	IDbTransaction transaction,
	CommandType commandType,
	string commandText,
	DataSet dataSet,
	string[] tableNames
)
Visual Basic
Public Overridable Sub FillDataset ( 
	transaction As IDbTransaction,
	commandType As CommandType,
	commandText As String,
	dataSet As DataSet,
	tableNames As String()
)

Parameters

transaction
Type: System.Data..::..IDbTransaction
A valid IDbTransaction
commandType
Type: System.Data..::..CommandType
The CommandType (stored procedure, text, etc.)
commandText
Type: System..::..String
The stored procedure name or SQL command
dataSet
Type: System.Data..::..DataSet
A dataset wich will contain the resultset generated by the command
tableNames
Type: array<System..::..String>[]()[][]
This array will be used to create table mappings allowing the DataTables to be referenced by a user defined name (probably the actual table name)

Examples

 Copy imageCopy
helper.FillDataset(tran, CommandType.StoredProcedure, "GetOrders", ds, new string[] {"orders"});

Exceptions

ExceptionCondition
System..::..ArgumentNullExceptionThrown if commandText is null
System..::..ArgumentNullExceptionThrown if transaction is null
System..::..ArgumentNullExceptionThrown if transaction.Connection is null

See Also