} //End Of Insert Function public static void InsertData(OTInfoclass stock) { string query = "INSERT INTO OrderTakerInfoTable (OrderTakerName,OrderTakerCompany,OrderTakerNumber ) VALUES('" + stock.Name.ToUpper() + "','" + stock.CompanyName.ToUpper() + "','" + stock.CompanyNumber.ToUpper() + "');"; 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) { OTInfoclass s = new OTInfoclass(); try { s.Name = txtName.Text.Trim(); s.CompanyName = txtcmpnyName.Text; // QueryClass.DeleteData(s); MessageBox.Show("Delete Successfully"); } catch (Exception ex) { MessageBox.Show("Error", ex.Message); } }
private void button1_Click(object sender, EventArgs e) { OTInfoclass os = new OTInfoclass(); try { os.Name = txtName.Text.Trim(); os.CompanyName = txtcmpnyName.Text.Trim(); os.CompanyNumber = txtNumber.Text; // QueryClass.InsertData(fs); MessageBox.Show("Add Successfully"); } catch (Exception ex) { MessageBox.Show("Error", ex.Message); } }