private void btn1_Click(object sender, EventArgs e) { PupilDBAccess PDBAccess = new PupilDBAccess(db); BookingDBAccess BDBAccess = new BookingDBAccess(db); InstrumentDBAccess IDBAccess = new InstrumentDBAccess(db); List <Pupil> pupils = new List <Pupil>(); Pupil Selected = new Pupil(); if (string.IsNullOrWhiteSpace(txtBoxID.Text)) { pupils = PDBAccess.getPupilByPupilName(txtBoxName.Text); } else { Selected = PDBAccess.getPupilByPupilNo(Convert.ToInt32(txtBoxID.Text)); pupils.Add(Selected); } CreateTableResults(pupils); }
private void btn1_Click(object sender, EventArgs e) { //Searches pupil by either pupilNo or LastName PupilDBAccess pupilAccess = new PupilDBAccess(db); List <Pupil> pupils = new List <Pupil>(); if (string.IsNullOrWhiteSpace(PupilNotxt.Text)) { pupils = pupilAccess.getPupilByPupilName(Nametxt.Text); } else { Selected = pupilAccess.getPupilByPupilNo(Convert.ToInt32(PupilNotxt.Text)); pupils.Add(Selected); } // Creates table with pupil information table = new DataTable(); table.Columns.Add("PupilNo"); table.Columns.Add("First Name"); table.Columns.Add("Last Name"); addpupil(pupils); }