public static int executeProcedure(string StoreProcName, SqlParameter[] param)
{
using (SqlConnection con = DBConnectionSQL.getConnection())
{
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = StoreProcName;
cmd.CommandType = CommandType.StoredProcedure;
if (param != null)
{
cmd.Parameters.AddRange(param);
}
return(cmd.ExecuteNonQuery());
}
}
}
public static DataSet gettable(string StoreProcName, SqlParameter[] param)
{
DataSet ds = new DataSet();
using (SqlConnection con = DBConnectionSQL.getConnection())
{
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = StoreProcName;
cmd.CommandType = CommandType.StoredProcedure;
if (param != null)
{
cmd.Parameters.AddRange(param);
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
da.Fill(ds);
}
return(ds);
}
}