homeadminClassfind.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 adminClassfind : System.Web.UI.Page
{
    SqlConnection conn;
    SqlCommand cmd,cmd1;
    SqlDataAdapter sda,sda1;
    DataSet ds,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();
        //if (this.DropDownList1.SelectedValue == "按班级号")
        //{
            string classID = this.key.Text;
            string sql = "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 where classID='" + classID + "'";
            //cmd = new SqlCommand(sql, conn);
            //SqlParameter id1 = new SqlParameter("@classID", SqlDbType.VarChar, 10);
            //id1.Value = classID;
            //cmd.Parameters.Add(id1);
            sda = new SqlDataAdapter(sql, conn);
            ds = new DataSet();
            sda.Fill(ds);
            this.GridView1.DataSource = ds;
            this.GridView1.DataBind();
        //}
        //else
        //{
        //    string className = this.key.Text;
        //    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 className='"+className+"'";
        //    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();
        //}
    }
}