default.aspx.cs

来自「水晶报表详细资料水晶报表详细资料水晶报表详细资料」· CS 代码 · 共 42 行

using System;
using System.Data;
using System.Configuration;
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 
{
    
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection myConn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());
        string strSqlStu = "select * from tb_StudentInfo";
        string strSqlCla = "select * from tb_ClassInfo";
        string strSqlSC = "select 学生编号,s.名称 as 学生姓名,年龄,c.名称 as 班级名称,班主任,班长 ";
        strSqlSC += "from tb_StudentInfo s inner Join tb_ClassInfo c on s.班级编号=c.班级编号";
        //绑定学生信息
        SqlDataAdapter adapterStu = new SqlDataAdapter(strSqlStu, myConn);
        DataSet dsStu = new DataSet();
        adapterStu.Fill(dsStu);
        this.GridView1.DataSource = dsStu.Tables[0].DefaultView;
        this.GridView1.DataBind();
        //绑定班级信息
        SqlDataAdapter adapterCla = new SqlDataAdapter(strSqlCla, myConn);
        DataSet dsCla = new DataSet();
        adapterCla.Fill(dsCla);
        this.GridView2.DataSource = dsCla.Tables[0].DefaultView;
        this.GridView2.DataBind();
        //绑定学生及学生所在班级信息
        SqlDataAdapter adapterSC = new SqlDataAdapter(strSqlSC, myConn);
        DataSet dsSC = new DataSet();
        adapterSC.Fill(dsSC);
        this.GridView3.DataSource = dsSC.Tables[0].DefaultView;
        this.GridView3.DataBind();
    }
}