Example #1
0
 /// <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));
 }
Example #2
0
 /// <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
     }));
 }
Example #3
0
 /// <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));
 }
Example #4
0
 /// <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
     }));
 }
Example #5
0
 /// <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);
 }
Example #6
0
 /// <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
     });
 }