Mediachase FileUploader.NET 1.9 Framework Help

SqlHelper.ExecuteReader Method (SqlTransaction, CommandType, String)

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

[Visual Basic]
Overloads Public Shared Function ExecuteReader( _
   ByVal transaction As SqlTransaction, _
   ByVal commandType As CommandType, _
   ByVal commandText As String _
) As SqlDataReader
[C#]
public static SqlDataReader ExecuteReader(
   SqlTransaction transaction,
   CommandType commandType,
   string commandText
);

Parameters

transaction
a valid SqlTransaction
commandType
the CommandType (stored procedure, text, etc.)
commandText
the stored procedure name or T-SQL command

Return Value

a SqlDataReader containing the resultset generated by the command

Remarks

e.g.: SqlDataReader dr = ExecuteReader(trans, CommandType.StoredProcedure, "GetOrders");

See Also

SqlHelper Class | Mediachase.FileUploader Namespace | SqlHelper.ExecuteReader Overload List