Mediachase FileUploader.NET 1.9 Framework Help

SqlHelper.ExecuteNonQuery Method

Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in the connection string.

Overload List

Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in the connection string.

public static int ExecuteNonQuery(SqlContext,CommandType,string);

Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in the connection string.

public static int ExecuteNonQuery(SqlContext,CommandType,string,params SqlParameter[]);

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

public static int ExecuteNonQuery(SqlConnection,CommandType,string);

Execute a SqlCommand (that returns no resultset) against the specified SqlConnection using the provided parameters.

public static int ExecuteNonQuery(SqlConnection,CommandType,string,params SqlParameter[]);

Execute a stored procedure via a SqlCommand (that returns no 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 int ExecuteNonQuery(SqlConnection,string,params object[]);

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

public static int ExecuteNonQuery(SqlTransaction,CommandType,string);

Execute a SqlCommand (that returns no resultset) against the specified SqlTransaction using the provided parameters.

public static int ExecuteNonQuery(SqlTransaction,CommandType,string,params SqlParameter[]);

Execute a stored procedure via a SqlCommand (that returns no 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 int ExecuteNonQuery(SqlTransaction,string,params object[]);

Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in the connection string.

public static int ExecuteNonQuery(string,CommandType,string);

Execute a SqlCommand (that returns no resultset) against the database specified in the connection string using the provided parameters.

public static int ExecuteNonQuery(string,CommandType,string,params SqlParameter[]);

Execute a stored procedure via a SqlCommand (that returns no 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 int ExecuteNonQuery(string,string,params object[]);

See Also

SqlHelper Class | Mediachase.FileUploader Namespace