} //End Of Insert Function //Delete public static void DeleteData(ExpenseClass sale) { string query = "Delete From ExpenseTable Where ExpenseName='" + sale.Nameexpense.ToUpper() + "' and Date='" + sale.Date.ToUpper() + "'"; try { DataTable _dTable = null; _dTable = dbAccess.ReadDataFromDb(query); } catch (Exception ex) { throw ex; } } //End Of delete Function
//Insert public static void InsertData(ExpenseClass stock) { string query = "INSERT INTO ExpenseTable (ExpenseName, ExpenseRS, Date ) VALUES('" + stock.Nameexpense.ToUpper() + "','" + stock.Rupees.ToUpper() + "','" + stock.Date + "' );"; try { DataTable _dtable = null; _dtable = dbAccess.ReadDataFromDb(query); } catch (Exception ex) { throw ex; } } //End Of Insert Function
private void button2_Click(object sender, EventArgs e) { ExpenseClass s = new ExpenseClass(); try { s.Nameexpense = txtName.Text.Trim(); s.Date = datetextbox.Text; QueryClass.DeleteData(s); MessageBox.Show("Delete Successfully"); } catch (Exception ex) { MessageBox.Show("Error", ex.Message); } }