} //End Of Insert Function public static void InsertData(OTClass stock) { string query = "INSERT INTO OrderTakerDemandTable (ProductName, Quantity ) VALUES('" + stock.Name.ToUpper() + "','" + stock.Quantity.ToUpper() + "');"; try { DataTable _dtable = null; _dtable = dbAccess.ReadDataFromDb(query); } catch (Exception ex) { throw ex; } } //End Of Insert Function
private void SaveBtn_Click(object sender, EventArgs e) { OTClass ss = new OTClass(); try { ss.Name = txtName.Text.Trim(); ss.Quantity = txtQuantity.Text.Trim(); QueryClass.InsertData(ss); MessageBox.Show("Add Successfully"); } catch (Exception ex) { MessageBox.Show("Error", ex.Message); } }