SqlHelper..::..FillDatasetAsync Method (SqlConnection, CommandType, String, DataSet, array<String>[]()[][])

Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.

Namespace: Core
Assembly: Core (in Core.dll)

Syntax

public static Task FillDatasetAsync(
	SqlConnection connection,
	CommandType commandType,
	string commandText,
	DataSet dataSet,
	string[] tableNames
)

Parameters

connection: Type: SqlConnection
A valid SqlConnection

commandType: Type: CommandType
The CommandType (stored procedure, text, etc.)

commandText: Type: String
The stored procedure name or T-SQL command

dataSet: Type: DataSet
A dataset wich will contain the resultset generated by the command

tableNames: Type: array<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)

Return Value

Task.

Remarks

e.g.: FillDatasetAsync(conn, CommandType.StoredProcedure, "GetOrders", ds, new string[] {"orders"});

See Also

SqlHelper Class

FillDatasetAsync Overload