教务系统可用代码，查询，删除，dropdownlist联动

 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
{
    SqlConnection conn = new SqlConnection();
    public void lianjie()
    {
        conn.ConnectionString = "Data Source=.//SQLEXPRESS;Initial Catalog=TeachingSystem;Integrated Security=True";
        conn.Open();
    }
    public string updateclass( string classname, string departmentname, string teacherid)
    {
            string str=null;
            string sqlstr = "update TS_class set TS_Class_name=@classname,TS_Class_department=@departmentname,TS_Class_teacherid=@teacherid ";
            SqlCommand comm = new SqlCommand(sqlstr, conn);
            try
            {
                //comm.Parameters.Add(new SqlParameter("@classid", SqlDbType.VarChar, 50));
                comm.Parameters.Add(new SqlParameter("@classname", SqlDbType.VarChar, 50));
                comm.Parameters.Add(new SqlParameter("@departmentname", SqlDbType.VarChar , 50));
                comm.Parameters.Add(new SqlParameter("@teacherid", SqlDbType.VarChar , 50));
               

                //comm.Parameters["@classid"].Value =classid ;
                comm.Parameters["@classname"].Value =classname ;
                comm.Parameters["@departmentname"].Value = departmentname ;
                comm.Parameters["@teacherid"].Value =teacherid ;
               
              //comm.Connection.Open();
                comm.ExecuteNonQuery();
         
                str = "更新成功";
             
            }
            catch (Exception ex)
            {
              
                str = ex.Message;
            }
            comm.Connection.Close();
            return str;      

    }
    public DataSet Query(string selectstr)
    {
        DataSet ds = new DataSet();
        try
        {
            SqlDataAdapter adp = new SqlDataAdapter(selectstr, conn);
            adp.Fill(ds);

        }
        catch (Exception)
        {

        }
        return ds;

    }

    public void TS_BindGrid()
    {
        lianjie();
        string sqlstr = "select * from TS_class";

        //DataSet ds =Query(sqlstr);
        DataSet ds = Query(sqlstr);
        conn.Close();
        GridView1.DataSource = ds;
        GridView1.DataBind();

    }

    protected void Page_Load(object sender, EventArgs e)
    {
       
    }   
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        //GridView1.EditIndex = (int)e.NewEditIndex;
        GridView1.EditIndex = (int)e.NewEditIndex;
        TS_BindGrid();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        lianjie();

        //string classid = GridView1.DataKeys[(int)e.RowIndex].Value.ToString();
        string classname = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
        string departmentname = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
        string teacherid = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
        string str = updateclass( classname, departmentname, teacherid);
        //conn.Close();
        Label1.Text = str;
        GridView1.EditIndex = -1;
        TS_BindGrid();

       
    }
    protected void Button1_Click(object sender, EventArgs e)
    {     

        lianjie();
        SqlCommand comm = new SqlCommand();
        comm.Connection = conn;
        comm.CommandText = "select * from TS_class where "+DropDownList1.SelectedValue +"='"+TextBox1 .Text +"'";
        DataSet ds = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = comm;
        sda.Fill(ds);
        conn.Close();      
        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        lianjie();
        SqlCommand comm = new SqlCommand();
        comm.Connection = conn;
        comm.CommandText = "select * from TS_class ";
        DataSet ds = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = comm;
        sda.Fill(ds);       
        comm.ExecuteNonQuery();
        conn.Close();
        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {

    }
}
 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (DropDownList1.SelectedItem.Text== "学号")
        {
            DropDownList2.Items.Clear();
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();

           SqlConnection conn=new SqlConnection();
           conn.ConnectionString = "Data Source=.;Initial Catalog=TeachingSystem;Integrated Security=True";
           conn.Open();

           SqlCommand comm = new SqlCommand();
           comm.Connection = conn;
           comm.CommandText = "select TS_Student_id from TS_student_course";

           SqlDataAdapter da = new SqlDataAdapter();
           da.SelectCommand = comm;
           da.Fill(ds);
           conn.Close();

           dt=ds.Tables[0];
        for (int i = 0; i < dt.Rows.Count; i++)
           {
             
             DropDownList2.Items.Add((string)(dt.Rows[i][0]));
           }
         }
        if (DropDownList1.SelectedItem.Text== "课程号")
        {
            DropDownList2.Items.Clear();
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
           SqlConnection conn=new SqlConnection();
           conn.ConnectionString = "Data Source=.;Initial Catalog=TeachingSystem;Integrated Security=True";
           conn.Open();

           SqlCommand comm = new SqlCommand();
           comm.Connection = conn;
           comm.CommandText = "select distinct TS_Course_id from TS_student_course";

           SqlDataAdapter da = new SqlDataAdapter();
           da.SelectCommand = comm;
           ds.Reset();
           da.Fill(ds);
           conn.Close();

           dt=ds.Tables[0];
            for (int i = 0; i < dt.Rows.Count; i++)
           {
                DropDownList2.Items.Add((string)(dt.Rows[i][0]));             
           }
        }
    }