protected void Page_Load(object sender, EventArgs e) { classes_result.InnerHtml = ""; string Semester = "all"; string search_key = ""; if (Page.IsPostBack) { search_key = classes_search.Text; Semester = semester.SelectedValue; } string query = "select * from CLASSES"; if (Semester != "all") { query += " WHERE (MONTH(STARTDATE) = " + Semester + ")"; //INITIAL WHERE SO BOTH SEARCH AND SEMESTER CAN RUN WITHOUT REPEATING THE WHERE IN THE SEARCH KEY IF } else { query += " WHERE (MONTH(STARTDATE) =01 OR MONTH(STARTDATE) =09) "; } if (search_key != "") { query += " AND (CLASSID LIKE '%" + search_key + "%'"; query += " OR CLASSCODE LIKE '%" + search_key + "%'"; query += " OR CLASSNAME LIKE '%" + search_key + "%')"; } //sql_debugger.InnerHtml = query; var db = new Schooldb(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { classes_result.InnerHtml += "<div class=\"listitem\">"; string classid = row["CLASSID"]; string classcode = row["CLASSCODE"]; classes_result.InnerHtml += "<div class=\"col4\"><a href=\"ClassInfo.aspx?classid=" + classid + "\">" + classcode + "</a></div>";; string classname = row["CLASSNAME"]; classes_result.InnerHtml += "<div class=\"col4\">" + classname + "</div>"; string classstartdate = row["STARTDATE"]; classes_result.InnerHtml += "<div class=\"col4\">" + classstartdate + "</div>"; string classenddate = row["FINISHDATE"]; classes_result.InnerHtml += "<div class=\"col4last\">" + classenddate + "</div>"; classes_result.InnerHtml += "</div>"; } }
protected void Page_Load(object sender, EventArgs e) { teachers_result.InnerHtml = ""; string search_key = ""; if (Page.IsPostBack) { search_key = teachers_search.Text; } string query = "select TEACHERID, concat(TEACHERFNAME,\", \",TEACHERLNAME) AS 'TEACHERNAME',EMPLOYEENUMBER,HIREDATE,SALARY from TEACHERS "; if (search_key != "") { query += " WHERE TEACHERID LIKE '%" + search_key + "%'"; query += " OR TEACHERFNAME LIKE '%" + search_key + "%'"; query += " OR TEACHERLNAME LIKE '%" + search_key + "%'"; query += " OR EMPLOYEENUMBER LIKE '%" + search_key + "%'"; query += " OR HIREDATE LIKE '%" + search_key + "%'"; query += " OR SALARY LIKE '%" + search_key + "%'"; } var db = new Schooldb(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { teachers_result.InnerHtml += "<div class=\"listitem\">"; string teacherid = row["TEACHERID"]; // teachers_result.InnerHtml += "<div class=\"col4\">" + teacherid + "</div>"; string teachername = row["TEACHERNAME"]; teachers_result.InnerHtml += "<div class=\"col4\"><a href=\"teacherData.aspx?teacherid=" + teacherid + "\">" + teachername + "</a></div>"; //string teacherlname = row["TEACHERLNAME"]; //teachers_result.InnerHtml += "<div class=\"col4\">" + teacherlname + "</div>"; string employeenumber = row["EMPLOYEENUMBER"]; teachers_result.InnerHtml += "<div class=\"col4\">" + employeenumber + "</div>"; string hiredate = row["HIREDATE"]; teachers_result.InnerHtml += "<div class=\"col4last\">" + hiredate + "</div>"; string salary = row["SALARY"]; teachers_result.InnerHtml += "<div class=\"col4last\">" + salary + "</div>"; teachers_result.InnerHtml += "</div>"; } }
//refference taken from in class example done by chrintine bittle protected void Page_Load(object sender, EventArgs e) { students_result.InnerHtml = ""; string search_key = ""; if (Page.IsPostBack) { search_key = student_search.Text; } string query = "select * from STUDENTS"; if (search_key != "") { query += " WHERE STUDENTFNAME LIKE '%" + search_key + "%'"; query += " OR STUDENTLNAME LIKE '%" + search_key + "%'"; query += " OR STUDENTNUMBER LIKE '%" + search_key + "%'"; } var db = new Schooldb(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { students_result.InnerHtml += "<div class=\"listitem\">"; string studentid = row["STUDENTID"]; string studentfirstname = row["STUDENTFNAME"]; students_result.InnerHtml += "<div class=\"col4\"><a href=\"ShowStudent.aspx?studentid=" + studentid + "\">" + studentfirstname + "</a></div>"; string studentlastname = row["STUDENTLNAME"]; students_result.InnerHtml += "<div class=\"col4\">" + studentlastname + "</div>"; string studentnumber = row["STUDENTNUMBER"]; students_result.InnerHtml += "<div class=\"col4\">" + studentnumber + "</div>"; string enrolmentdate = row["ENROLMENTDATE"]; students_result.InnerHtml += "<div class=\"col4last\">" + enrolmentdate + "</div>"; students_result.InnerHtml += "</div>"; } }