protected void Page_Load(object sender, EventArgs e) { if (Session["stunum"] != null || Session["adminnum"] != null || Session["thnnum"] != null) { Session.Abandon(); } DataBaseUtil.connectDB(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["stunum"] == null) { Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>"); } else { DataBaseUtil.connectDB(); } }
protected void bind() { string tnum = Session["thnnum"].ToString(); DataBaseUtil.connectDB(); string showSql = " select tb_student.sno,sname,tb_course.cno,cname,grade from tb_course,tb_sc,tb_teacher,tb_student where tb_course.cno=tb_sc.cno and tb_sc.tno=tb_teacher.tno and tb_sc.sno=tb_student.sno and tb_sc.tno='" + tnum + "'"; DataSet ds = new DataSet(); SqlDataAdapter myDA = new SqlDataAdapter(showSql, myconn); myDA.Fill(ds, "TEST"); GridView1.DataSource = ds; GridView1.DataBind(); }
public void dBind() { DataBaseUtil.connectDB(); string snum = Session["stunum"].ToString(); string showSql = "select sno ,sname ,ssex, sbirth, mname from tb_student join tb_major on tb_student.mno=tb_major.mno and sno='" + snum + "'"; SqlDataAdapter sda = new SqlDataAdapter(showSql, myconn); DataSet ds = new DataSet(); sda.Fill(ds, "stutab"); GridView1.DataSource = ds; GridView1.DataBind(); }
public void dBind() { DataBaseUtil.connectDB(); string tnum = Session["thnnum"].ToString(); string showSql = "select tno ,dno ,tname, tsex from tb_teacher where tno='" + tnum + "'"; SqlDataAdapter sda = new SqlDataAdapter(showSql, myconn); DataSet ds = new DataSet(); sda.Fill(ds, "thtab"); GridView1.DataSource = ds; GridView1.DataBind(); }
public void dBind() { DataBaseUtil.connectDB(); string anum = Session["adminnum"].ToString(); string showSql = "select ano ,aname ,apass from tb_admin where ano='" + anum + "'"; SqlDataAdapter sda = new SqlDataAdapter(showSql, myconn); DataSet ds = new DataSet(); sda.Fill(ds, "admintab"); GridView1.DataSource = ds; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["adminname"] == null) { Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>"); } else if (Session["adminright"].ToString() == "10" || Session["adminright"].ToString() == null) { Response.Write("<script>alert('您没有权限使用此功能');window.location.href='AdminInfo.aspx'</script>"); } else { DataBaseUtil.connectDB(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["adminname"] == null) { Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>"); } else { DataBaseUtil.connectDB(); string ssql = "select mno as '专业编号',mname as '专业名称',tb_major.dno as '系别编号',dname as '系别',dtel as '联系方式' from tb_major join tb_dept on tb_major.dno=tb_dept.dno"; SqlDataAdapter sda = new SqlDataAdapter(ssql, myconn); DataSet ds = new DataSet(); sda.Fill(ds, "mdInfo"); GridView1.DataSource = ds; GridView1.DataBind(); } }
protected void bind() { if (Session["thnnum"] == null) { Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>"); } else { string tnum = Session["thnnum"].ToString(); DataBaseUtil.connectDB(); string showSql = " select cno as '课程号',cname as '课程名',ccredit as '学分',tno as '本人教师编号' from tb_course where tno='" + tnum + "'"; DataSet ds = new DataSet(); SqlDataAdapter myDA = new SqlDataAdapter(showSql, myconn); myDA.Fill(ds, "TEST"); GridView1.DataSource = ds; GridView1.DataBind(); } }
protected void bind() { if (Session["stunum"] == null) { Response.Write("<script>alert('请先登录!');window.location.href='Login.aspx'</script>"); } else { string studentNum = Session["stunum"].ToString(); DataBaseUtil.connectDB(); string showSql = " select tb_course.cno as '课程号',cname as '课程名',ccredit as '学分',tname as '教师名',dname as '系别',dtel as '联系方式' from tb_course,tb_sc,tb_teacher,tb_dept where tb_course.cno=tb_sc.cno and tb_sc.tno=tb_teacher.tno and tb_teacher.dno=tb_dept.dno and tb_sc.sno='" + studentNum + "'"; DataSet ds = new DataSet(); SqlDataAdapter myDA = new SqlDataAdapter(showSql, myconn); myDA.Fill(ds, "TEST"); GridView1.DataSource = ds; GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { //Label1.Text = Session["stuname"].ToString();//test Session DataBaseUtil.connectDB(); }