chaxun.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
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (CheckBox1.Checked)
            TextBox1.Visible = true;

        if (CheckBox2.Checked)
            RadioButtonList1.Visible = true;

        if (CheckBox3.Checked)
            TextBox2.Visible = true;

        if (CheckBox4.Checked)
            TextBox3.Visible = true;

        if (!CheckBox1.Checked)
            TextBox1.Visible = false;

        if (!CheckBox2.Checked)
            RadioButtonList1.Visible = false;
        if (!CheckBox3.Checked)
            TextBox2.Visible = false;

        if (!CheckBox4.Checked)
            TextBox3.Visible = false;
       
    }


    protected void Button2_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.;Database=xueji; Integrated Security=SSPI";
        conn.Open();
        string ssss = "select * from student where 1=1 ";

        if (CheckBox1.Checked)
        {
            ssss = ssss + " and adept='" + TextBox1.Text + "'";
            SqlDataAdapter da = new SqlDataAdapter(ssss, conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "grade");
            DataTable dt = ds.Tables["grade"];
            GridView1.DataSource = ds.Tables["grade"].DefaultView;
            GridView1.DataBind();
            conn.Close();

        }
        if (CheckBox2.Checked)
        {
            ssss = ssss + " and Sex='" + RadioButtonList1.Text + "'";
            SqlDataAdapter db = new SqlDataAdapter(ssss, conn);
            DataSet dq = new DataSet();
            db.Fill(dq, "grade");
            DataTable dz = dq.Tables["grade"];
            GridView1.DataSource = dq.Tables["grade"].DefaultView;
            GridView1.DataBind();
            conn.Close();

        }
        if (CheckBox3.Checked)
        {
            ssss = ssss + " and name='" + TextBox2.Text + "'";
            SqlDataAdapter dd = new SqlDataAdapter(ssss, conn);
            DataSet dc = new DataSet();
            dd.Fill(dc, "grade");
            DataTable dy = dc.Tables["grade"];
            GridView1.DataSource = dc.Tables["grade"].DefaultView;
            GridView1.DataBind();
            conn.Close();

        }
        if (CheckBox4.Checked)
        {
            ssss = ssss + "and class1='" + TextBox3.Text + "'";
            SqlDataAdapter df = new SqlDataAdapter(ssss, conn);
            DataSet dw = new DataSet();
            df.Fill(dw, "grade");
            DataTable dm = dw.Tables["grade"];
            GridView1.DataSource = dw.Tables["grade"].DefaultView;
            GridView1.DataBind();
            conn.Close();
        }


        conn.Close();
    }
}