protected void btnFindStudent_Click(object sender, EventArgs e) { // Reset the page. lblResultMessage.Visible = false; pnlStudentRecord.Visible = false; if (Page.IsValid) { string studentId = myHelpers.CleanInput(txtStudentId.Text); //************** // Uses TODO 1 * //************** DataTable dtStudentRecord = myUniversityDB.GetStudentRecord(studentId); // Show the student record if the query result is not null and something was retrieved. if (dtStudentRecord != null) { // Display a no result message if nothing was retrieved from the database. if (dtStudentRecord.Rows.Count != 0) { gvStudentRecord.DataSource = dtStudentRecord; gvStudentRecord.DataBind(); pnlStudentRecord.Visible = true; } else // Display a no result message. { myHelpers.ShowMessage(lblResultMessage, "No record for the student was found."); } } else // An SQL error occurred. { myHelpers.ShowMessage(lblResultMessage, "*** There is an error in the SQL statement of TODO 1."); } } }
/*----- Protected Methods -----*/ protected void BtnFindStudent_Click(object sender, EventArgs e) { // Hide previous results. lblResultMessage.Visible = false; pnlStudentRecord.Visible = false; string studentId = myHelperMethods.CleanInput(txtStudentId.Text); if (IsValid && StudentIdIsValid(studentId)) { //*************** // Uses TODO 01 * //*************** DataTable dtStudentRecord = myUniversityDB.GetStudentRecord(studentId); // Attributes expected to be returned by the query result. var attributeList = new List <string> { "STUDENTID", "FIRSTNAME", "LASTNAME", "EMAIL", "PHONENO", "CGA", "DEPARTMENTID", "ADMISSIONYEAR" }; // Display the query result if it is valid. if (myHelperMethods.IsQueryResultValid("TODO 01", dtStudentRecord, attributeList, lblResultMessage)) { // Display a no result message if nothing was retrieved from the database. if (dtStudentRecord.Rows.Count != 0) { gvStudentRecord.DataSource = dtStudentRecord; gvStudentRecord.DataBind(); pnlStudentRecord.Visible = true; } else // Display a no result message. { myHelperMethods.DisplayMessage(lblResultMessage, "No record for the student was found."); } } } }