/// <summary> /// Executes a stored procedure and returns the scalar result /// </summary> /// <param name="storedProcedureName">Name of the of the stored procedure being executed</param> /// <param name="parameter">Single parameter to pass to the stored procedure</param> /// <param name="conn">Open connection to the database</param> /// <returns>The scalar result of executing the stored procedure</returns> public static object ExecuteScalar(String storedProcedureName, sp.Parameter parameter, SqlConnection conn) { return(ExecuteScalar(storedProcedureName, new sp.Parameter[1] { parameter }, conn)); }
/// <summary> /// Executes a stored procedure and returns the scalar result /// </summary> /// <param name="storedProcedureName">Name of the of the stored procedure being executed</param> /// <param name="parameter">Single parameter to pass to the stored procedure</param> /// <returns>The scalar result of executing the stored procedure</returns> public static object ExecuteScalar(String storedProcedureName, sp.Parameter parameter) { return(ExecuteScalar(storedProcedureName, new sp.Parameter[1] { parameter })); }
/// <summary> /// Executes a stored procedure and returns the selected data /// </summary> /// <param name="storedProcedureName">Name of the of the stored procedure being executed</param> /// <param name="parameter">Single parameter to pass to the stored procedure</param> /// <param name="conn">Open connection to the database</param> /// <returns>The data selected by the stored procedure</returns> public static sp.DataTable ExecuteReader(String storedProcedureName, sp.Parameter parameter, SqlConnection conn) { return(ExecuteReader(storedProcedureName, new sp.Parameter[1] { parameter }, conn)); }
/// <summary> /// Executes a stored procedure and returns the selected data /// </summary> /// <param name="storedProcedureName">Name of the of the stored procedure being executed</param> /// <param name="parameter">Single parameter to pass to the stored procedure</param> /// <returns>The data selected by the stored procedure</returns> public static sp.DataTable ExecuteReader(String storedProcedureName, sp.Parameter parameter) { return(ExecuteReader(storedProcedureName, new sp.Parameter[1] { parameter })); }
/// <summary> /// Executes a stored procedure /// </summary> /// <param name="storedProcedureName">Name of the of the stored procedure being executed</param> /// <param name="parameter">Single parameter to pass to the stored procedure</param> /// <param name="conn">Open connection to the database</param> public static void ExecuteNonQuery(String storedProcedureName, sp.Parameter parameter, SqlConnection conn) { ExecuteNonQuery(storedProcedureName, new sp.Parameter[1] { parameter }, conn); }
/// <summary> /// Executes a stored procedure /// </summary> /// <param name="storedProcedureName">Name of the of the stored procedure being executed</param> /// <param name="parameter">Single parameter to pass to the stored procedure</param> public static void ExecuteNonQuery(String storedProcedureName, sp.Parameter parameter) { ExecuteNonQuery(storedProcedureName, new sp.Parameter[1] { parameter }); }