Execute an IDbCommand (that returns a resultset and takes no parameters) against the provided IDbConnection.
Namespace: CodeSmith.EngineAssembly: CodeSmith.Engine (in CodeSmith.Engine.dll) Version: 6.0.0.0 (7.0.0.15127)
Syntax
C# |
---|
public virtual void FillDataset( IDbConnection connection, CommandType commandType, string commandText, DataSet dataSet, string[] tableNames ) |
Visual Basic |
---|
Public Overridable Sub FillDataset ( connection As IDbConnection, commandType As CommandType, commandText As String, dataSet As DataSet, tableNames As String() ) |
Parameters
- connection
- Type: System.Data..::..IDbConnection
A valid IDbConnection
- 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 | |
---|---|
helper.FillDataset(conn, CommandType.StoredProcedure, "GetOrders", ds, new string[] {"orders"}); |
Exceptions
Exception | Condition |
---|---|
System..::..ArgumentNullException | Thrown if commandText is null |
System..::..ArgumentNullException | Thrown if connection is null |