public static DataTable Execute_Query(SqlCommand cmd) { cmd.Connection = Create_Connection.open_Connection(); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public static int Execute_Non_Query(SqlCommand cmd) { try { cmd.Connection = Create_Connection.open_Connection(); cmd.CommandType = CommandType.StoredProcedure; return(cmd.ExecuteNonQuery()); } finally { Create_Connection.close_Connection(); } }