private void button9_Click(object sender, EventArgs e) { DBConnector dbConn = new DBConnector(); dbConn.connect(); LabourerHandler labHnd = new LabourerHandler(); List <Labourer> theList = labHnd.getAllLabourer(dbConn.getConn()); // for all dataGridView1.DataSource = theList; }
private void button7_Click(object sender, EventArgs e) { DBConnector dbConn = new DBConnector(); dbConn.connect(); Labourer labr = new Labourer(); labr.Name = textBox6.Text; labr.Age = int.Parse(textBox7.Text); labr.Gender = textBox8.Text; LabourerHandler labHnd = new LabourerHandler(); int recordCnt = labHnd.addNewLabourer(dbConn.getConn(), labr); MessageBox.Show(recordCnt + " record has been inserted !!"); }