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