/*----- Protected Methods -----*/ protected void DdlDepartments_SelectedIndexChanged(object sender, EventArgs e) { // Hide previous results. lblResultMessage.Visible = false; pnlSearchResult.Visible = false; Page.Validate(); if (IsValid) { // Get the department id from the dropdown list. string departmentId = ddlDepartments.SelectedItem.Value; //*************** // Uses TODO 03 * //*************** DataTable dtStudentRecords = myUniversityDB.GetDepartmentStudentRecords(departmentId); // Attributes expected to be returned by the query result. var attributeList = new List <string> { "STUDENTID", "LASTNAME", "FIRSTNAME", "EMAIL", "CGA" }; // Display the query result if it is valid. if (myHelperMethods.IsQueryResultValid("TODO 03", dtStudentRecords, attributeList, lblResultMessage)) { if (dtStudentRecords.Rows.Count != 0) { gvFindStudentRecordsResult.DataSource = dtStudentRecords; gvFindStudentRecordsResult.DataBind(); pnlSearchResult.Visible = true; } else // Display a no result message. { myHelperMethods.DisplayMessage(lblResultMessage, "There are no students in the " + ddlDepartments.SelectedItem.Text + " department."); } } } }
protected void btnFindStudentRecords_Click(object sender, EventArgs e) { if (Page.IsValid) { // Reset the page. lblResultMessage.Visible = false; pnlSearchResult.Visible = false; // Get the department id from the dropdown list. string departmentId = ddlDepartments.SelectedItem.Value; //************** // Uses TODO 3 * //************** DataTable dtStudentRecords = myUniversityDB.GetDepartmentStudentRecords(departmentId); // Show the student records if the query result is not null and something was retrieved. if (dtStudentRecords != null) { if (dtStudentRecords.Rows.Count != 0) { gvFindStudentRecordsResult.DataSource = dtStudentRecords; gvFindStudentRecordsResult.DataBind(); pnlSearchResult.Visible = true; } else // Display a no result message. { myHelpers.ShowMessage(lblResultMessage, "There are no students in the " + ddlDepartments.SelectedItem.Text + " department."); } } else // An SQL error occurred. { myHelpers.ShowMessage(lblResultMessage, "*** There is an error in the SQL statement of TODO 3."); } } }