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.closeConnection();
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.generateCustomerCode();
}
