using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace DataShowApplication
{
    public partial class IndexO : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        protected void GridViewOne_PageIndexChanging(object sender, GridViewPageEventArgs e) 
        {
            //获取当前分页的索引值
            this.GridViewOne.PageIndex = e.NewPageIndex;
            this.GridViewOne.DataBind();
        }
    }
}

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

namespace DataShowApplication
{
    public partial class IndexTwo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //调用绑定方法
                this.BindData();
            }
        }
        //写一个绑定数据的方法
        private void BindData()
        {
            //老一套连接字符串先走起
            string strconn = @"Data Source=.\CENA;Initial Catalog=Asp.net;Persist Security Info=True;User ID=sa;Password=123456";
            //写SQL  有SQL语句了才能有数据(其实标准的SQL语句基本都是大写的看大牛一般都那样写)
            string sqlquery = "select * from DemoStu";
            //准备好了就要创建数据库连接对象
            SqlConnection connection = new SqlConnection(strconn);
            //然后在搞一个数据适配器
            SqlDataAdapter da = new SqlDataAdapter(sqlquery, strconn);
            //继续创建数据集合
            DataSet ds = new DataSet();
            //填充数据集
            da.Fill(ds);
            //设置咱GridView控件数据源为创建的数据集ds
            this.GridViewTwo.DataSource = ds;
            //将数据库表中的主键字段放入GridView控件的DataKeyNames属性中
            this.GridViewTwo.DataKeyNames = new string[] { "ID" };
            //绑定数据库中的数据
            this.GridViewTwo.DataBind();
        }

        protected void RowEditing(object sender, GridViewEditEventArgs e) 
        {
            //设置索引值
            this.GridViewTwo.EditIndex = e.NewEditIndex;
            this.BindData();
        }
        protected void GridViewTwo_RowUpdating(object sender, GridViewUpdatedEventArgs e)
        {
            //取得编辑行的关键字段的值
            string ID = this.GridViewTwo.DataKeys[e.RowIndex].Value.ToString();
            //取得文本框中输入的内容
            string Name = ((TextBox)(this.GridViewTwo.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
            string Price = ((TextBox)(this.GridViewTwo.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
            string time = ((TextBox)(this.GridViewTwo.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
            //定义更新操作的SQL语句
            string update_sql = "update DemoStu set Name=‘" + Name + "‘,Price=‘" + Price + "‘,Time=‘" + time + "‘ where id=‘" + ID + "‘";
            bool update = ExceSQL(update_sql);//调用ExceSQL执行更新操作
            if (update)
            {
                Response.Write("<script language=javascript>alert(‘修改成功！‘)</script>");
                //设置GridView控件的编辑项的索引为－1，即取消编辑
                this.GridViewTwo.EditIndex = -1;
                BindData();
            }
            else
            {
                Response.Write("<script language=javascript>alert(‘修改失败！‘);</script>");
            }
        }

        protected void GridViewTwo_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) 
        {
            //设置GridView控件的编辑项的索引为－1，即取消编辑
            this.GridViewTwo.EditIndex = -1;
            BindData();
        }

        protected void GridViewTwo_RowDeleting(object sender, GridViewDeletedEventArgs e)
        {
            string delete_sql = "delete from DemoStu where id=‘" + this.GridViewTwo.DataKeys[e.RowIndex].Value.ToString() + "‘";
            bool delete = ExceSQL(delete_sql);//调用ExceSQL执行删除操作
            if (delete)
            {
                Response.Write("<script language=javascript>alert(‘删除成功！‘)</script>");
                BindData();//调用自定义方法重新绑定控件中数据
            }
            else
            {
                Response.Write("<script language=javascript>alert(‘删除失败！‘)</script>");
            }
        }

        /// <summary>
        /// 执行SQL语句的方法
        /// </summary>
        /// <param name="update_sql"></param>
        /// <returns></returns>
        private bool ExceSQL(string update_sql)
        {
            //定义数据库连接字符串
            string strCon = @"Data Source=.\CENA;Initial Catalog=Asp.net;Persist Security Info=True;User ID=sa;Password=123456";
            //创建数据库连接对象
            SqlConnection sqlcon = new SqlConnection(strCon);
            SqlCommand sqlcom = new SqlCommand(update_sql, sqlcon);
            try
            {
                if (sqlcon.State == System.Data.ConnectionState.Closed)//判断数据库是否为连连状态
                { sqlcon.Open(); }
                sqlcom.ExecuteNonQuery();//执行SQL语句
                return true;
            }
            catch
            {
                return false;
            }
            finally
            {
                sqlcon.Close();//关闭数据库连接
            }
        }


    }
}