GridView操作

里面包含了GridView大部分的操作
并且配合Dropdownlist 和 联动

编辑时的联动定位可能写的不是很好

忘有大神提出优化

using System;using System.Collections.Generic;using System.Configuration;using System.Data;using System.Data.SqlClient;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;namespace TestSQL{    public partial class index1 : System.Web.UI.Page    {        string _connectionString = ConfigurationManager.AppSettings["ConnectionString"];        protected void Page_Load(object sender, EventArgs e)        {            /*            if (HttpContext.Current.Session["UserName"] == null)            {                Response.Write("<script>alert('非法登录！请重新登录');window.location.href='Login.aspx'</script>");                //Response.Redirect("Login.aspx", false);             }*/         //   SessionLogin.Login1();            if (!IsPostBack)            {                this.Bind();            }        }        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)        {            //HiddenField hd = ((Label)GridView1.Rows[e.NewEditIndex].FindControl("Label2")).Text;            // string b = ((Label)(GridView1.Rows[e.NewEditIndex].FindControl("Label3"))).Text.ToString();            string Sname = (GridView1.Rows[e.NewEditIndex].FindControl("Label2") as Label).Text;//获取label的值            string ClassN = (GridView1.Rows[e.NewEditIndex].FindControl("Label3") as Label).Text;//获取label的值            GridView1.EditIndex = e.NewEditIndex;            this.Bind();            DropDownList ddl = (DropDownList)GridView1.Rows[e.NewEditIndex].FindControl("DropDownList1");            ddl.SelectedValue = Sname;            SqlConnection conn = new SqlConnection(_connectionString);            conn.Open();            DropDownList DropDownList1 = (DropDownList)GridView1.Rows[e.NewEditIndex].FindControl("DropDownList1"); //得到当前的DropDownList            string Specialty_Name = DropDownList1.SelectedValue;            string strSQL = "SELECT class_name FROM class  WHERE Specialty_ID=(SELECT ID FROM   Specialty WHERE Specialty_Name='" + Specialty_Name + "' ) ";            DataSet ds = new DataSet();            DataTable dt = new DataTable();            SqlDataAdapter adp = new SqlDataAdapter(strSQL, conn);            adp.Fill(ds, "Class");            dt = ds.Tables["Class"];            GridViewRow dvr = (GridViewRow)DropDownList1.NamingContainer;            DropDownList DropDownList2 = (DropDownList)dvr.FindControl("DropDownList2");            DropDownList2.Items.Clear();            for (int i = 0; i < dt.Rows.Count; i++)            {                DropDownList2.Items.Add(dt.Rows[i]["class_name"].ToString());            }            conn.Close();            DropDownList2.SelectedValue = ClassN;        }        protected void Bind()        {            DataSet ds = new DataSet();            SqlConnection sqlconn = new SqlConnection(_connectionString);            SqlDataAdapter sqld = new SqlDataAdapter("select * from student", sqlconn);            sqld.Fill(ds, "tabstudent");            GridView1.DataSource = ds.Tables["tabstudent"].DefaultView;            GridView1.DataBind();            Label1.Text = "查找成功";          }        //更新操作        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)        {            SqlConnection conn = new SqlConnection(_connectionString);            DropDownList ddl = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownList1");            string Specialty_Name = ddl.SelectedValue;            DropDownList ddl2 = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownList2");            string Class_Name = ddl2.SelectedValue;            string strSQL = "update student set student_name="                +"'" +((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "'"                +",Sex="                + "'" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "'"                + ",Specialty="                + "'"+Specialty_Name+"'"                + ",Class="                + "'" + Class_Name + "'"                +"where Student_id="                   + "'"+GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";            SqlCommand cmd = new SqlCommand(strSQL, conn);            conn.Open();            cmd.ExecuteNonQuery();            conn.Close();            GridView1.EditIndex = -1;            Bind();            Label1.Text = "更新成功";          }        //GridView取消按钮操作        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)        {            GridView1.EditIndex = -1;            this.Bind();        }        //GridView删除操作        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)        {            string a = GridView1.Rows[e.RowIndex].Cells[4].Text;            string b = ((Label)(GridView1.Rows[e.RowIndex].FindControl("Label2"))).Text;            SqlConnection conn = new SqlConnection(_connectionString);            string strSQL = "DELETE Student WHERE Student_id = "                + "'" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";            SqlCommand cmd = new SqlCommand(strSQL, conn);            conn.Open();            //cmd.ExecuteNonQuery();            conn.Close();            GridView1.EditIndex = -1;            Bind();            Label1.Text = "删除成功";          }        //专业DropDownlist绑定数据        public DataSet ddlBind() {            SqlConnection conn = new SqlConnection(_connectionString);            conn.Open();            SqlDataAdapter adp = new SqlDataAdapter("SELECT Specialty_Name FROM Specialty ",conn);            DataSet ds = new DataSet();            adp.Fill(ds, "Specialty");            conn.Close();            return ds;        }        //下拉变化事件，级联的实现效果        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)        {            SqlConnection conn = new SqlConnection(_connectionString);            conn.Open();                        DropDownList DropDownList1 = (DropDownList)sender; //得到当前的DropDownList            string Specialty_Name = DropDownList1.SelectedValue;            string strSQL = "SELECT class_name FROM class  WHERE Specialty_ID=(SELECT ID FROM   Specialty WHERE Specialty_Name='" + Specialty_Name + "' ) ";            DataSet ds = new DataSet();            DataTable dt = new DataTable();            SqlDataAdapter adp = new SqlDataAdapter(strSQL, conn);            adp.Fill(ds, "Class");            dt = ds.Tables["Class"];            GridViewRow dvr = (GridViewRow)DropDownList1.NamingContainer; //获取对DropDownList的容器引用            //得到dvr后就好办了查找下面的子控件。            DropDownList DropDownList2 = (DropDownList)dvr.FindControl("DropDownList2");            DropDownList2.Items.Clear();            for (int i = 0; i < dt.Rows.Count; i++)            {                DropDownList2.Items.Add(dt.Rows[i]["class_name"].ToString());            }            //DropDownList2.SelectedIndex = DropDownList1.SelectedIndex;            conn.Close();        }        public void ReadLoadDroplist() {         }        protected void Button1_Click(object sender, EventArgs e)        {            DropDownList ddl = (DropDownList)GridView1.Rows[0].FindControl("DropDownList1");            ddl.SelectedValue = "Android開發與應用";        }    }}

原创文章