public string getAllStudents() { StudentDataSetTableAdapters.studentsTableAdapter student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); StudentDataSet.studentsDataTable student_query_data = new StudentDataSet.studentsDataTable(); student_query_data = student_table.GetData(); string bind = ""; for (int i = 0; i < student_query_data.Count; i++) { bind += "<tr><td> " + (i + 1) + "</td><td>" + student_query_data[i].sid + "</td><td> " + student_query_data[i].username + " </td><td> " + student_query_data[i].fname + " </td><td> " + student_query_data[i].lname + " </td><td> " + student_query_data[i].gender + "</td><td> " + student_query_data[i].email + " </td><td> " + student_query_data[i].number + " </td><td> " + student_query_data[i].password + " </td><td> " + student_query_data[i].usertype + " </td><td> " + student_query_data[i].department + " </td><td> " + student_query_data[i].cgpa + " </td><td> " + student_query_data[i].semester + " </td></tr> "; } return(bind); }
protected void Page_Load(object sender, EventArgs e) { if (Session["usertype"] != null) { if ((Session["usertype"].ToString() == "admin") || (Session["usertype"].ToString() == "Admin")) { string username = Session["username"].ToString(); string password = Session["password"].ToString(); student_table = new StudentDataSetTableAdapters.studentsTableAdapter(); student_query_data = new StudentDataSet.studentsDataTable(); admin_query_data = admin_table.Login(username, password); student_query_data = student_table.GetData(); } else if ((Session["usertype"].ToString() == "student") || (Session["usertype"].ToString() == "Student")) { Response.Redirect("~/Student.aspx"); } } else { Response.Redirect("~/Login.aspx"); } }