private void dtgList_CellClick(object sender, DataGridViewCellEventArgs e) { sql = "SELECT `IDNO`, CONCAT( `LNAME`,', ', `FNAME`,' ', `MNAME`) as 'FULL NAME', `SEX`" + ", `AGE`, `HOME_ADD` as 'ADDRESS'" + " FROM `tblstudent` WHERE `IDNO` = '" + dtgList.CurrentRow.Cells[0].Value + "'"; config.singleResult(sql); if (config.dt.Rows.Count > 0) { txtFullname.Text = config.dt.Rows[0].Field <string>("FULL NAME"); sql = " SELECT * FROM `tblstudupdatelevel` " + "WHERE `IDNO` ='" + dtgList.CurrentRow.Cells[0].Value + "'"; config.singleResult(sql); if (config.dt.Rows.Count > 0) { txtLevel.Text = config.dt.Rows[0].Field <string>("LEVEL"); txtSection.Text = config.dt.Rows[0].Field <string>("SECTION"); } else { txtLevel.Text = "New"; txtSection.Text = "New"; } sql = "SELECT ACADYR FROM ay"; config.fiil_CBO(sql, cbosy); sql = "SELECT LEVEL FROM `level`"; config.combo(sql, cboLevel); cbosection.DataSource = null; cbosection.Text = "Select"; //sql = "SELECT SECTION FROM `tblsection`"; //config.fiil_CBO(sql, cbosection); dtgSubject.Columns.Clear(); } }