public void DeleteRecords(string query) { try { SqlConnection con = DBConnection.connection(); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { throw ex; } }
public static int CRUDRecords(string query) { try { int i = 1; SqlConnection con = DBConnection.connection(); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return(i); } catch (Exception ex) { throw ex; } }
public static DataTable GetData(string proc) { SqlConnection con = DBConnection.connection(); DataTable allData = new DataTable(); try { SqlCommand cmd = new SqlCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(allData); con.Close(); } catch { con.Close(); } return(allData); }