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