private void btnBrowseStudent_Click(object sender, EventArgs e)
{
string query = "SELECT * FROM StudentPersonalInfo";
FrmBrowse frmBrowse = new FrmBrowse(query);
DialogResult dr = frmBrowse.ShowDialog();
if (dr == DialogResult.OK)
{
txtStudentNumber.Text = frmBrowse.ReturnValueFirstColumn;
}
SetStudentPersonalInfo();
}
private void btnBrowse_Click(object sender, EventArgs e)
{
string query = string.Format("SELECT SR.StudentNo, (LastName + ',' + FirstName + ' ' + MiddleName) AS Name, * " +
"FROM StudentRecord AS SR INNER JOIN StudentPersonalInfo AS SP " +
"ON SP.StudentNo = SR.StudentNo WHERE GradeLevelID = {0} AND SchoolYear = {1}",
lblGradeLevelID.Text, GlobalVariable.SchoolYear);
FrmBrowse frmBrowse = new FrmBrowse(query);
DialogResult dr = frmBrowse.ShowDialog();
if (dr == DialogResult.OK)
{
txtStudentNumber.Text = frmBrowse.ReturnValueFirstColumn;
lblStudentName.Text = frmBrowse.ReturnValueSecondColumn;
}
}
private void btnBrowseStudent_Click(object sender, EventArgs e)
{
//Select students with no records in current year.
string query = "SELECT * FROM StudentPersonalInfo SP " +
"WHERE NOT EXISTS (SELECT StudentNo FROM StudentRecord SR WHERE SchoolYear = " + GlobalVariable.SchoolYear + " " +
"AND SP.StudentNo = SR.StudentNo)";
FrmBrowse frmBrowse = new FrmBrowse(query);
DialogResult dr = frmBrowse.ShowDialog();
if (dr == DialogResult.OK)
{
txtStudentNumber.Text = frmBrowse.ReturnValueFirstColumn;
}
SetStudentPersonalInfo();
}
