teacherqueryelect.aspx.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 _Default : System.Web.UI.Page
{
    SqlConnection conn ;
    protected void Page_Load(object sender, EventArgs e)
    {
        string connStr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
       conn= new SqlConnection(connStr);
       SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter("SELECT Student.stuID,Student.stuName,Student.stuGrade,Student.stuClass from Elect,Student,Cource where Elect.stuID=Student.stuID and Elect.CourceID=Cource.CourceID and Elect.CourceID='" + ddlCource.SelectedValue.ToString() + "'", conn);

       DataSet dsDataSet = new DataSet();

       sqlDataAdapter1.Fill(dsDataSet, "dsDataSet ");

       //使用SqlDataAdapter的Fill方法填充DataSet

       conn.Close();

       //关闭数据连接

       Session["DataSet"] = dsDataSet;
       teaID.Text = Session["userName"].ToString();
       string sqlselect = "select teaID,teaName from teacher where teacher.teaID='" + Session["userName"].ToString() + " '";
       SqlCommand comm1 = new SqlCommand(sqlselect, conn);
       conn.Open();
       SqlDataReader dr = comm1.ExecuteReader();
       if (dr.Read())
       {
           teaName.Text = dr["teaName"].ToString();
           teaID.Text = dr["teaID"].ToString();
       }
       conn.Close();


        if (!this.IsPostBack)
        {            
            BindDDL();
            //stu_Bind();
        }
    
    }
    
    private void BindDDL()
    {


        string SqlStr = "SELECT  cource.courceID,cource.courceName from Cource where Cource.teaID='" + Session["userName"].ToString() + "'";
        DataSet ds = new DataSet();
          
        if (conn.State.ToString() == "Closed")             
            conn.Open();
        SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
        da.Fill(ds);                                        
        if (conn.State.ToString() == "Open")
            conn.Close();

        ddlCource.DataSource = ds.Tables[0].DefaultView;
        ddlCource.DataTextField = "courceName";             
        ddlCource.DataValueField = "courceID";              
        ddlCource.DataBind();
    }
    //protected void stu_Bind()
    //{
    //    string SqlStr1 = "SELECT Student.stuID,Student.stuName,Student.stuGrade,Student.stuClass from Elect,Student,Cource where Elect.stuID=Student.stuID and Elect.CourceID=Cource.CourceID and Elect.CourceID='" + ddlCource.DataValueField + "'";
    //    DataSet ds1 = new DataSet();
    //    if (conn.State.ToString() == "Closed")
    //        conn.Open();
    //    SqlDataAdapter da1 = new SqlDataAdapter(SqlStr1 ,conn);
    //    da1.Fill(ds1 );
    //    if (conn.State.ToString() == "Open")
    //        conn.Close();
    //    GridView1.DataSource = ds1;
    //    GridView1.DataBind();
    //}

    protected void xiugaiPwd_Click(object sender, EventArgs e)
    {
        Response.Redirect("ModifyPwd.aspx");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string SqlStr1 = "SELECT Student.stuID,Student.stuName,Student.stuGrade,Student.stuClass from Elect,Student,Cource where Elect.stuID=Student.stuID and Elect.CourceID=Cource.CourceID and Elect.CourceID='" + ddlCource.SelectedValue.ToString()+ "'";
        DataSet ds1 = new DataSet();
        if (conn.State.ToString() == "Closed")
            conn.Open();
        SqlDataAdapter da1 = new SqlDataAdapter(SqlStr1, conn);
        da1.Fill(ds1);
        if (conn.State.ToString() == "Open")
            conn.Close();
        GridView1.DataSource = ds1;
        GridView1.DataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Page.RegisterClientScriptBlock("open", "<script   language='javascript'>window.open('showReport.aspx','_blank')</script>");
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Redirect("Login.aspx");
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        Response.Redirect("teachershangchuan.aspx");
    }
}