Create and prepare a SqlCommand, and call ExecuteReader with the appropriate CommandBehavior.
Create and prepare a SqlCommand, and call ExecuteReader with the appropriate CommandBehavior.
public static SqlDataReader ExecuteReader(SqlContext,CommandType,string);
Create and prepare a SqlCommand, and call ExecuteReader with the appropriate CommandBehavior.
public static SqlDataReader ExecuteReader(SqlContext,CommandType,string,params SqlParameter[]);
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
public static SqlDataReader ExecuteReader(SqlConnection,CommandType,string);
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
public static SqlDataReader ExecuteReader(SqlConnection,CommandType,string,params SqlParameter[]);
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
public static SqlDataReader ExecuteReader(SqlConnection,string,params object[]);
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
public static SqlDataReader ExecuteReader(SqlTransaction,CommandType,string);
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
public static SqlDataReader ExecuteReader(SqlTransaction,CommandType,string,params SqlParameter[]);
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
public static SqlDataReader ExecuteReader(SqlTransaction,string,params object[]);
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
public static SqlDataReader ExecuteReader(string,CommandType,string);
Execute a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameters.
public static SqlDataReader ExecuteReader(string,CommandType,string,params SqlParameter[]);
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
public static SqlDataReader ExecuteReader(string,string,params object[]);
SqlHelper Class | Mediachase.FileUploader Namespace