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