//Display All The Schools public void BindDetails() { School.Registration obj = new School.Registration(); DataSet ds = obj.DisplayCustomRegDet(); //Bind Schools DropDownListSchool.DataTextField = "schname"; DropDownListSchool.DataValueField = "schid"; DropDownListSchool.DataSource = ds.Tables[0]; DropDownListSchool.DataBind(); DropDownListSchool.Items.Insert(0, new ListItem("Select Your School", "")); DropDownListState.Items.Insert(0, new ListItem("select your state", "")); DropDownListState.Items.Insert(0, new ListItem("select you city", "")); //Bind Classes DropDownListClass.DataTextField = "clsnam"; DropDownListClass.DataValueField = "clsid"; DropDownListClass.DataSource = ds.Tables[1]; DropDownListClass.DataBind(); DropDownListClass.Items.Insert(0, new ListItem("Select Your Class", "")); //Bind Sections DropDownListSection.DataTextField = "secnam"; DropDownListSection.DataValueField = "secid"; DropDownListSection.DataSource = ds.Tables[2]; DropDownListSection.DataBind(); DropDownListSection.Items.Insert(0, new ListItem("Select Your Section", "")); ds.Dispose(); ds = null; }
protected void Page_Load(object sender, EventArgs e) { if (Session["Admin"] == null) { return; } Admin a = (Admin)Session["Admin"]; LabelUserName.Text = a.MaGv1; if (!IsPostBack) { DropDownListClass.DataTextField = "TenLop"; DropDownListClass.DataValueField = "MaLop"; DropDownListClass.DataSource = Lop.getAllClass(); DropDownListClass.DataBind(); GridViewSinhVien.DataSource = SinhVien.getAllSinhVien(); GridViewSinhVien.DataBind(); DropDownListKhoa.DataTextField = "TenKhoa1"; DropDownListKhoa.DataValueField = "MaKhoa1"; DropDownListKhoa.DataSource = Khoa.GetKhoas(); DropDownListKhoa.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { role = (string)Session["role"]; if (!this.IsPostBack) { role = ""; DropDownListID.DataSource = SqlDataSource1; DropDownListID.DataBind(); DropDownListID.Items.Add(new ListItem("Select ID")); DropDownListID.ClearSelection(); DropDownListID.Items.FindByValue("Select ID").Selected = true; DropDownListClass.DataSource = SqlDataSource2; DropDownListClass.DataBind(); DropDownListClass.Items.Add(new ListItem("Select Class")); DropDownListClass.ClearSelection(); DropDownListClass.Items.FindByValue("Select Class").Selected = true; DropDownListCourse.DataSource = SqlDataSource3; DropDownListCourse.DataBind(); DropDownListCourse.Items.Add(new ListItem("Select Course")); DropDownListCourse.ClearSelection(); DropDownListCourse.Items.FindByValue("Select Course").Selected = true; } if ((string)Session["user"] == "") { ClientScript.RegisterStartupScript(Page.GetType(), "alert", "alert('Please log in first');window.location='LoginPage.aspx';", true); } user = "******" + (string)(Session["user"]); }
protected void Page_Load(object sender, EventArgs e) { //获取所有班级 SqlConnection sqlConnection = SqlTools.Connection(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select * from classinfo", sqlConnection); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet); //所有班级绑定到班级下拉框 DropDownListClass.DataSource = dataSet; DropDownListClass.DataTextField = "name"; DropDownListClass.DataBind(); //获取所有系别 SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter("select * from dept", sqlConnection); DataSet dataSet1 = new DataSet(); sqlDataAdapter1.Fill(dataSet1); //所有系别绑定到系别下拉框 DropDownListDept.DataSource = dataSet1; DropDownListDept.DataTextField = "name"; DropDownListDept.DataBind(); sqlConnection.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //获取要编辑学生 string id = Request.QueryString["id"]; Student s = (Student)dao.getBody(id, 1); TextBoxID.Text = s.ID1; TextBoxName.Text = s.Name1; TextBoxPassword.Text = s.Password1; TextBoxBirth.Text = s.Birth1; TextBoxEmail.Text = s.Email1; TextBoxPhone.Text = s.Telephone1; TextBoxAddress.Text = s.Address1; TextBoxState.Text = s.State1; if (s.Sex1.Equals("女")) { RadioButtonSexFemale.Checked = true; } else { RadioButtonSexMale.Checked = true; } //获取所有班级 SqlConnection sqlConnection = SqlTools.Connection(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select * from classinfo", sqlConnection); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet); //所有班级绑定到班级下拉框 DropDownListClass.DataSource = dataSet; DropDownListClass.DataTextField = "name"; DropDownListClass.DataBind(); //下拉框选中该学生班级 DropDownListClass.SelectedValue = s.Class1; //获取所有系别 SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter("select * from dept", sqlConnection); DataSet dataSet1 = new DataSet(); sqlDataAdapter1.Fill(dataSet1); //所有系别绑定到系别下拉框 DropDownListDept.DataSource = dataSet1; DropDownListDept.DataTextField = "name"; DropDownListDept.DataBind(); //下拉框选中该学生系别 DropDownListDept.SelectedValue = s.Dept1; sqlConnection.Close(); } //不能改学号 TextBoxID.Enabled = false; }
protected void Page_Load(object sender, EventArgs e) { SqlConnection sqlConnection = SqlTools.Connection(); //获取所有课程名 SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter("select * from course", sqlConnection); DataSet dataSet1 = new DataSet(); sqlDataAdapter1.Fill(dataSet1); //所有课程名绑定到课程号下拉框 DropDownListCourse.DataSource = dataSet1; DropDownListCourse.DataTextField = "name"; DropDownListCourse.DataBind(); //获取所有教室 SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter("select * from classroom", sqlConnection); DataSet dataSet2 = new DataSet(); sqlDataAdapter2.Fill(dataSet2); //所有教室绑定到地点下拉框 DropDownListPlace.DataSource = dataSet2; DropDownListPlace.DataTextField = "id"; DropDownListPlace.DataBind(); //获取所有班级 SqlDataAdapter sqlDataAdapter3 = new SqlDataAdapter("select * from classinfo", sqlConnection); DataSet dataSet3 = new DataSet(); sqlDataAdapter3.Fill(dataSet3); //所有班级绑定到班级下拉框 DropDownListClass.DataSource = dataSet3; DropDownListClass.DataTextField = "name"; DropDownListClass.DataBind(); sqlConnection.Close(); }
protected void DropDownListID_SelectedIndexChanged(object sender, EventArgs e) { string id = DropDownListID.SelectedValue; string role2; if (id == "Select ID") { role = ""; DropDownListCourse.Visible = false; course.Visible = false; DropDownListClass.ClearSelection(); DropDownListClass.Items.FindByValue("Select Class").Selected = true; DropDownListCourse.ClearSelection(); DropDownListCourse.Items.FindByValue("Select Course").Selected = true; } else { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); conn.Open(); string uname = "SELECT role FROM UserData WHERE id = '" + id + "'"; SqlCommand com = new SqlCommand(uname, conn); role2 = com.ExecuteScalar().ToString().Trim(); role = role2; Session["role"] = role2; conn.Close(); if (role2 == "Teacher") { DropDownListCourse.Visible = true; RequiredFieldValidator4.Enabled = true; course.Visible = true; } else { DropDownListCourse.Visible = false; RequiredFieldValidator4.Enabled = false; course.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //获取要编辑课程 string id = Request.QueryString["id"]; Exam ex = (Exam)dao.getBody(id, 7); TextBoxID.Text = ex.ID; TextBoxDate.Text = ex.Date; SqlConnection sqlConnection = SqlTools.Connection(); //获取所有课程名 SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter("select * from course", sqlConnection); DataSet dataSet1 = new DataSet(); sqlDataAdapter1.Fill(dataSet1); //所有课程名绑定到课程号下拉框 DropDownListCourse.DataSource = dataSet1; DropDownListCourse.DataTextField = "name"; DropDownListCourse.DataBind(); //选中 DropDownListCourse.SelectedValue = ex.Course; //获取所有教室 SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter("select * from classroom", sqlConnection); DataSet dataSet2 = new DataSet(); sqlDataAdapter2.Fill(dataSet2); //所有教室绑定到地点下拉框 DropDownListPlace.DataSource = dataSet2; DropDownListPlace.DataTextField = "id"; DropDownListPlace.DataBind(); //选中 DropDownListPlace.SelectedValue = ex.Place; //获取所有班级 SqlDataAdapter sqlDataAdapter3 = new SqlDataAdapter("select * from classinfo", sqlConnection); DataSet dataSet3 = new DataSet(); sqlDataAdapter3.Fill(dataSet3); //所有班级绑定到班级下拉框 DropDownListClass.DataSource = dataSet3; DropDownListClass.DataTextField = "name"; DropDownListClass.DataBind(); //选中 DropDownListClass.SelectedValue = ex.ClassInfo; //绑定考试时间 string[] dayAndNode = ex.Time.Split(','); for (int i = 0; i < dayAndNode.Length; i++) { //第一个字符为1说明是星期一 if (dayAndNode[i].Substring(0, 1).Equals("1")) { RadioButtonMonday.Checked = true; DropDownListMonday.SelectedValue = dayAndNode[i].Substring(2, 1); } else if (dayAndNode[i].Substring(0, 1).Equals("2")) { RadioButtonTuesday.Checked = true; DropDownListTuesday.SelectedValue = dayAndNode[i].Substring(2, 1); } else if (dayAndNode[i].Substring(0, 1).Equals("3")) { RadioButtonWed.Checked = true; DropDownListWednesday.SelectedValue = dayAndNode[i].Substring(2, 1); } else if (dayAndNode[i].Substring(0, 1).Equals("4")) { RadioButtonThur.Checked = true; DropDownListThursday.SelectedValue = dayAndNode[i].Substring(2, 1); } else if (dayAndNode[i].Substring(0, 1).Equals("5")) { RadioButtonFri.Checked = true; DropDownListFriday.SelectedValue = dayAndNode[i].Substring(2, 1); } } sqlConnection.Close(); } //不能改课程号 TextBoxID.Enabled = false; }