} //End Of Insert Function public static void InsertData(SalesManInfoClass stock) { string query = "INSERT INTO SalesManTable (SalesmanName,SalesmanQualification,SalesmanCity,SalesmanPhoneNumber ) VALUES('" + stock.Name.ToUpper() + "','" + stock.Qualification.ToUpper() + "','" + stock.City.ToUpper() + "' ,'" + stock.Number + "');"; try { DataTable _dtable = null; _dtable = dbAccess.ReadDataFromDb(query); } catch (Exception ex) { throw ex; } } //End Of Insert Function
private void btnSave_Click(object sender, EventArgs e) { if (txtName.Text == "" || txtNumber.Text == "") { MessageBox.Show("Please Fill The Form Above."); } else { SalesManInfoClass ps = new SalesManInfoClass(); try { ps.Name = txtName.Text.Trim(); ps.Qualification = txtQualification.Text.Trim(); ps.City = txtCity.Text; ps.Number = txtNumber.Text; QueryClass.InsertData(ps); MessageBox.Show("Add Successfully"); } catch (Exception ex) { MessageBox.Show("Error", ex.Message); } } }