【ADO.NET基础-GridView】GridView的编辑、更新、取消、删除以及相关基础操作代码

"GridView1" runat="server" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" AutoGenerateColumns="False" CellPadding="3" CellSpacing="1" GridLines="None" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnSelectedIndexChanged="Page_Load" DataKeyNames="SID" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging" PageSize="8" OnRowDataBound="GridView1_RowDataBound"  >
             
               "#C6C3C6" ForeColor="Black" />
              "#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
               "NumericFirstLast" />
              "#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
              "#DEDFDE" ForeColor="Black" />          
              "#F1F1F1" />
              "#594B9C" />
              "#CAC9C9" />
              "#33276A" />
              "password" HeaderText="编号" ReadOnly="true" />
                   "SID" HeaderText="学号" ReadOnly="true" />
                   "name" HeaderText="姓名"  ControlStyle-Width="100"/>
                   "sex" HeaderText="性别"  ControlStyle-Width="30"/>
                  "age" HeaderText="年龄" ControlStyle-Width="30"/>
                   "address" HeaderText="地址"  ControlStyle-Width="250"/>
                   "phone" HeaderText="电话"  ControlStyle-Width="70"/>
                   "qq" HeaderText="QQ" ControlStyle-Width="70"/>
                   "time" HeaderText="注册时间"  HtmlEncode="false" DataFormatString="{0:yyyy-M-dd}" ReadOnly="true"/>
                 "Button" HeaderText="操作" ShowDeleteButton="True" ShowEditButton="True"/>

              

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

namespace ado.netDemo1
{
    public partial class Test1 : System.Web.UI.Page
    {
        SqlConnection connStr = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ToString());
        protected void Page_Load(object sender, EventArgs e)
        {
            //string connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString();
            //SqlConnection conn = new SqlConnection(connStr);
            //conn.Open();
            //string sql = "select * from tb_Students";
            //SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
            //DataSet dataset = new DataSet();
            //adapter.Fill(dataset);
            //conn.Close();
            //GridView1.DataSource = dataset.Tables[0].ToString();
            //GridView1.DataBind();

            if(!IsPostBack)
            {
                shuaxin();
            }
            
        }

        //刷新数据
        private void shuaxin()

        {



            connStr.Open();
            string sql = "select * from tb_Students";
            SqlDataAdapter da = new SqlDataAdapter(sql, connStr);
            DataSet ds = new DataSet();
            da.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)

            {

                GridView1.DataSource = ds;
              
                GridView1.DataBind();

            }
            GridView1.DataKeyNames = new string[] { "SID" };
            connStr.Close();

        }

        //编辑
        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            GridView1.EditIndex = e.NewEditIndex;
            shuaxin();
        }
        //取消编辑
        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            GridView1.EditIndex = -1;
            shuaxin();
        }
        //更新
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            //( Name, Password, Sex, Age, Address, Phone, QQ)
            string sql = "update tb_Students set Name=‘"
                +((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() +"‘,Sex=‘"
                +((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "‘,Age=‘"
                +((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "‘,Address=‘"
                +((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "‘,Phone=‘"
                +((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim() + "‘,QQ=‘"
                +((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim() +"‘where SID=‘"
                + GridView1.DataKeys[e.RowIndex].Value.ToString().Trim()+ "‘";
            connStr.Open();
            SqlCommand cmd = new SqlCommand(sql,connStr);
            int EXQ = cmd.ExecuteNonQuery();
            if (EXQ == 1)
            {
                Response.Write("");
            }
            else
            {
                Response.Write("");
            }
            connStr.Close();
            GridView1.EditIndex = -1;
            shuaxin();


        }

        //删除
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
           
            string sql = "delete from tb_Students where SID=‘"+GridView1.DataKeys[e.RowIndex].Value.ToString()+"‘";
            connStr.Open();
            SqlCommand cmd = new SqlCommand(sql,connStr);
            int EXQ = cmd.ExecuteNonQuery();
            if (EXQ == 1)
            {
                Response.Write("");
            }
            else
            {
                Response.Write("");
            }
            connStr.Close();
            shuaxin();
            

        }
        //分页
        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            shuaxin();
            GridView1.PageIndex = e.NewPageIndex;
            GridView1.DataBind();
        }
        //编号
        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {

            //编号以及鼠标经过的背景更改
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                ////鼠标经过时，行背景色变
                e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor=‘#95CACA‘");
                ////鼠标移出时，行背景色变
                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=‘#F0F0F0‘");

                ////当有编辑列时，避免出错，要加的RowState判断
                //if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)
                //{
                // ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm(‘你确认要删除：/"" + e.Row.Cells[1].Text + "/"吗?‘)");
                //}

            }
            if (e.Row.RowIndex != -1)
            {
                int id = e.Row.RowIndex + 1;
                e.Row.Cells[0].Text = id.ToString();
            }

        }

    }
}