masterpage.master.cs

学生网上选课系统,实现了学生的在线选课和教师课程的上传

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class MasterPage : System.Web.UI.MasterPage
{
    SqlConnection conn;
    protected void Page_Load(object sender, EventArgs e)
    {
        string myCon = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
        conn = new SqlConnection(myCon);

        //if (!this.IsPostBack)
        //{
        //    BindGrid();
        //}
        ////string sql2 = "select Elect.stuID,Elect.courceID,Elect.teaID,Cource.courceName,Teacher.teaName,Cource.courceTime,Cource.courceAddress,Cource.credit,Cource.xueshi,Cource.courceInfo FROM Elect INNER JOIN Cource ON Elect.courceID=Cource.courceID AND Elect.teaID=Cource.teaID INNER JOIN Teacher ON Elect.teaID=Teacher.teaID AND Cource.teaID=Teacher.teaID where (Elect.stuID=@stuID)";
        ////DataSet myds2 = new DataSet();
        ////SqlDataAdapter myda2 = new SqlDataAdapter(sql2, conn);
        ////myda.Fill(myds2);
        ////GridView2.DataSource = myds2;
        ////GridView2.DataBind();
        stuID.Text = Session["userName"].ToString();
        string sqlselect = "select stuID,stuName,stuClass from student where student.stuID='" + Session["userName"].ToString() + " '";
        SqlCommand comm1 = new SqlCommand(sqlselect, conn);
        conn.Open();
        SqlDataReader dr = comm1.ExecuteReader();
        if (dr.Read())
        {
            stuName.Text = dr["stuName"].ToString();
            stuClass.Text = dr["stuClass"].ToString();
        }
        conn.Close();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("Login.aspx");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("elect.aspx");
    }
    protected void modifyPwd_Click(object sender, EventArgs e)
    {
        Response.Redirect("ModifyPwd.aspx");
    }
    protected void zhuanyeke_Click(object sender, EventArgs e)
    {
        Response.Redirect("Studentzhuanyeke.aspx");
    }
    protected void jichuke_Click(object sender, EventArgs e)
    {
        Response.Redirect("studentjichuke.aspx");
    }
    protected void xuanxiuke_Click(object sender, EventArgs e)
    {
        Response.Redirect("studentxuanxiuke.aspx");
    }
    protected void fanhui_Click(object sender, EventArgs e)
    {
        Response.Redirect("studentElect.aspx");
    }
}