studClassFind.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 classFind : System.Web.UI.Page
{
    SqlConnection conn;
    SqlCommand cmd1, cmd2;
    SqlDataAdapter sda1;
    DataSet ds1;

    protected void Page_Load(object sender, EventArgs e)
    {
        this.Panel1.Visible = false;
    }
    
    protected void btn_OK_Click(object sender, EventArgs e)
    {
        conn = sqldata.createCon();
        conn.Open();
        string classID = this.ddlClass.SelectedValue;
        string sql1 = "select studNo as 学号,studName as 姓名,Sex as 性别,birthday as 出生日期,enterDate as 入学时间,eareName as 区域名,floodName as 楼栋名,homeNo as 寝室号,shenfen as 身份 from (((home inner join flood on home.floodID=flood.floodID)inner join eare on flood.eareID=eare.eareID)inner join student on student.homeID=home.homeID)inner join class on student.classID=class.classID where class.classID='" + classID + "'";
        //cmd1 = new SqlCommand(sql1,conn);
        //SqlParameter id2 = new SqlParameter("@className", SqlDbType.VarChar, 20);
        //id2.Value = className;
        //cmd1.Parameters.Add(id2);
        sda1 = new SqlDataAdapter(sql1, conn);
        ds1 = new DataSet();
        sda1.Fill(ds1);
        this.GridView1.DataSource = ds1;
        this.GridView1.DataBind();
        conn.Close();
    }
}