} //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);
}
}
