Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
public static DataSet ExecuteDataset(SqlContext,CommandType,string);
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
public static DataSet ExecuteDataset(SqlContext,CommandType,string,params SqlParameter[]);
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
public static DataSet ExecuteDataset(SqlConnection,CommandType,string);
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
public static DataSet ExecuteDataset(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 DataSet ExecuteDataset(SqlConnection,string,params object[]);
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
public static DataSet ExecuteDataset(SqlTransaction,CommandType,string);
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
public static DataSet ExecuteDataset(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 DataSet ExecuteDataset(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 DataSet ExecuteDataset(string,CommandType,string);
Execute a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameters.
public static DataSet ExecuteDataset(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 DataSet ExecuteDataset(string,string,params object[]);
SqlHelper Class | Mediachase.FileUploader Namespace