private void btn_add_Click(object sender, EventArgs e) { try { Database db = new Database(); db.openConnection(); bool test = Validte_Data(); if (test == true) { String cusId = CodeGenerator.generateCustomerID(); string query = "INSERT INTO customers VALUES ('" + cusId + "','" + txt_cus_fname.Text + "', '" + txt_cus_lname.Text + "', '" + txt_cus_NIC.Text + "', '" + txt_cus_mobile.Text + "', '" + txt_cus_addrees_L1.Text + "','" + txt_cus_addrees_L2.Text + "','" + txt_cus_city.Text + "','" + txt_cus_email.Text + "')"; db.sqlQuery(query); db.nonQuery(); loadData(); } db.getConnection().Close(); } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex)); } }
public void loadData() { Database db = new Database(); db.openConnection(); String q1 = "SELECT * FROM customers"; db.sqlQuery(q1); DataTable dt = db.executeQuery(); bunifuCustomDataGrid1.DataSource = dt; db.getConnection().Close(); for (int i = 0; i < bunifuCustomDataGrid1.Columns.Count; i++) { bunifuCustomDataGrid1.Columns[i].Visible = false; } bunifuCustomDataGrid1.Columns[0].Visible = true; bunifuCustomDataGrid1.Columns[0].HeaderText = "ID"; bunifuCustomDataGrid1.Columns[1].Visible = true; bunifuCustomDataGrid1.Columns[1].HeaderText = "First Name"; bunifuCustomDataGrid1.Columns[2].Visible = true; bunifuCustomDataGrid1.Columns[2].HeaderText = "Last Name"; bunifuCustomDataGrid1.Columns[3].Visible = true; bunifuCustomDataGrid1.Columns[3].HeaderText = "NIC"; bunifuCustomDataGrid1.Columns[7].Visible = true; bunifuCustomDataGrid1.Columns[7].HeaderText = "City"; bunifuCustomDataGrid1.Columns[4].Visible = true; bunifuCustomDataGrid1.Columns[4].HeaderText = "Mobile"; btn_update.Visible = false; btn_remove.Visible = false; btn_add.Enabled = true; clear(); txt_cus_id.Text = CodeGenerator.generateCustomerID(); }