protected void Page_Load(object sender, EventArgs e) { if (Session["otherUser"] == null) { Id = Session["Id"].ToString(); AccountID = Session["AccountId"].ToString(); } else { Id = Session["otherUser"].ToString(); AccountID = Session["otherAccountId"].ToString(); } if (!IsPostBack) //check if the webpage is loaded for the first time. { ViewState["PreviousPage"] = Request.UrlReferrer;//Saves the Previous page url in ViewState } 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(); } }
protected void Canel_Click(object sender, EventArgs e) { Panel1.Visible = false; maindiv.Visible = true; con.Close(); 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(); }
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(); } } }