protected void GVTeacher_PageIndexChanging(object sender, GridViewPageEventArgs e) { GVTeacher.PageIndex = e.NewPageIndex; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teacher.Department = Department.DId "; // string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teaccher.Department = Department.DId "; SqlDataAdapter sda = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); sda.Fill(dt); GVTeacher.DataSource = dt; GVTeacher.DataBind(); con.Close(); } ConfirmMsg.Text = ""; }
private void ShowTeacher() { LearnSite.BLL.Teacher tbll = new LearnSite.BLL.Teacher(); GVTeacher.DataSource = tbll.GetTeacherList(); GVTeacher.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { try { if (!Session["ConfirmReg"].Equals("")) { ConfirmMsg.Text = "Account has been created successfully"; } else { ConfirmMsg.Text = ""; } } catch (Exception ex) { ConfirmMsg.Text = ""; } if (!IsPostBack) //check if the webpage is loaded for the first time. { ViewState["PreviousPage"] = Request.UrlReferrer;//Saves the Previous page url in ViewState } if (!Page.IsPostBack) { try { if (Session["Index"].Equals("0")) { DDSelectUser.SelectedIndex = 0; stdView.Visible = true; TeacherView.Visible = false; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); SqlDataAdapter sda = new SqlDataAdapter("Select * from Student ", con); DataTable dt = new DataTable(); sda.Fill(dt); GvStudent.DataSource = dt; GvStudent.DataBind(); con.Close(); } } if (Session["Index"].Equals("1")) { DDSelectUser.SelectedIndex = 1; stdView.Visible = false; CPView.Visible = true; TeacherView.Visible = false; Label2.Visible = false; using (SqlConnection con = new SqlConnection(conString)) { string cp = "ChairPerson"; con.Open(); SqlDataAdapter sda = new SqlDataAdapter("SELECT Department.DId,Department.DepartmentName,Department.TId,Teacher.TName,Teacher.TId FROM Department INNER JOIN Teacher ON Department.TId = Teacher.TId ", con); DataTable dt = new DataTable(); sda.Fill(dt); GVCP.DataSource = dt; GVCP.DataBind(); con.Close(); } } if (Session["Index"].Equals("2")) { DDSelectUser.SelectedIndex = 2; stdView.Visible = false; CPView.Visible = false; TeacherView.Visible = true; Label2.Visible = true; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teacher.Department = Department.DId "; // string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teaccher.Department = Department.DId "; SqlDataAdapter sda = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); sda.Fill(dt); GVTeacher.DataSource = dt; GVTeacher.DataBind(); con.Close(); } } } catch (Exception ex) { // Session["Index"] = ""; DDSelectUser.SelectedIndex = 0; stdView.Visible = true; TeacherView.Visible = false; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); SqlDataAdapter sda = new SqlDataAdapter("Select * from Student ", con); DataTable dt = new DataTable(); sda.Fill(dt); GvStudent.DataSource = dt; if (dt.Rows[0][13].ToString().Equals("1")) { } GvStudent.DataBind(); con.Close(); } } } //if(Page.IsPostBack) //{ //} }
protected void DDSelectUser_SelectedIndexChanged(object sender, EventArgs e) { if (DDSelectUser.SelectedIndex == 0) { Session["Index"] = "0"; ConfirmMsg.Text = ""; stdView.Visible = true; CPView.Visible = false; TeacherView.Visible = false; Label2.Visible = true; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); SqlDataAdapter sda = new SqlDataAdapter("Select * from Student ", con); DataTable dt = new DataTable(); sda.Fill(dt); GvStudent.DataSource = dt; if (dt.Rows[0][13].ToString().Equals("1")) { } GvStudent.DataBind(); con.Close(); } } else if (DDSelectUser.SelectedIndex == 2) { Session["Index"] = "2"; ConfirmMsg.Text = ""; stdView.Visible = false; CPView.Visible = false; TeacherView.Visible = true; Label2.Visible = true; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teacher.Department = Department.DId "; // string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teaccher.Department = Department.DId "; SqlDataAdapter sda = new SqlDataAdapter(query, con); DataTable dt = new DataTable(); sda.Fill(dt); GVTeacher.DataSource = dt; GVTeacher.DataBind(); con.Close(); } } else if (DDSelectUser.SelectedIndex == 1) { Session["Index"] = "1"; ConfirmMsg.Text = ""; stdView.Visible = false; CPView.Visible = true; TeacherView.Visible = false; Label2.Visible = false; using (SqlConnection con = new SqlConnection(conString)) { string cp = "ChairPerson"; con.Open(); SqlDataAdapter sda = new SqlDataAdapter("SELECT Department.DId,Department.DepartmentName,Department.TId,Teacher.TName,Teacher.TId FROM Department INNER JOIN Teacher ON Department.TId = Teacher.TId ", con); DataTable dt = new DataTable(); sda.Fill(dt); GVCP.DataSource = dt; GVCP.DataBind(); con.Close(); } } }