C# GridView使用 与 DataList分页。

3. 使用"编辑" 功能
          1  先添加一列 "编辑、更新、取消"
          2  GridView 属性的 事件里 有RowEditing 双击进入后台：

  protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        int index = e.NewEditIndex;
        this.GridView1.EditIndex = index;
       //这样写是错误的： this.GridView1.DataBind();
        this.InitGridView();
    }

4 . 使用更新 UpDating

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        int id = -1;
        string ot_name = string.Empty;
        string way = string.Empty;
        string fenlei = string.Empty;

        try
        {
            id = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex].Value);
        }
        catch
        {
 
        }
        TextBox tb = (TextBox)(this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]);
        TextBox tb1 = (TextBox)(this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0]);
        TextBox tb2 = (TextBox)(this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0]);
        if (tb != null)
        {
            ot_name = tb.Text;
        }
        if (tb1 != null)
        {
            way = tb1.Text;
        }
        if (tb2 != null)
        {
            fenlei = tb2.Text;
        }
        bool bo = false;
        bo = new ChuLi.Class1().Updating(ot_name, way, fenlei,id);
        if (bo == true)
        {
            this.RegisterStartupScript("sss", "<script>alert('修改成功')</script>");
        }
        else
        {
            this.RegisterStartupScript("sss", "<script>alert('修改失败')</script>");
        }
        this.GridView1.EditIndex = -1;
        this.InitGridView();
       
    }

5. 取消更新
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        this.InitGridView();
    }

6 . 删除

      protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int id = -1;
        try
        {
             id = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex].Value);
        }
        catch { }
        bool bo1 = new ChuLi.Class1().Deleting(id);
        if (bo1 == true)
        {
            this.RegisterStartupScript("ssa", "<script>alert('删除成功')</script>");
        }
        else
        {
            this.RegisterStartupScript("ssd", "<script>alert('删除失败')</script>");
        }
        this.GridView1.EditIndex = -1;
        this.InitGridView();
    }
-grid----------------------------------------------------------------list-----------

 

 

 

 #region 分页
        private void getFebye()
        {

            string sql = string.Format("select top 10 * from Book where xianshi = '1' order by addtime desc");
            DataTable dt = new DataTable();
            dt = database.GetSqlReturnDT(sql);

            if (dt == null || dt.Rows.Count == 0)
            {
                this.Label1.Text = "暂无数据";
            }
            else
            {
                this.Label1.Text = string.Empty;
            }

            this.DataList1.DataSource = dt;
            this.DataList1.DataBind();

            string sql_countFy = string.Format("select count(*) from Book where xianshi = '1'");
            object countFy = database.GetSqlReutrnObj(sql_countFy);
            if (countFy != null)
            {
                int zongtiaoshu = Convert.ToInt32(countFy.ToString());
                this.TiaoCountL.Text = zongtiaoshu.ToString();  //总条数
                int zongyeshu = 0;
                if (zongtiaoshu % 10 != 0)
                {
                    zongyeshu = zongtiaoshu / 10 + 1;
                    this.YeCountL.Text = zongyeshu.ToString();
                }
                else
                {
                    zongyeshu = zongtiaoshu / 10;
                    this.YeCountL.Text = zongyeshu.ToString();
                }
            }
            else
            {
                //没有数据
            }

        }
        protected void LinkButton1_Click(object sender, EventArgs e) //首页
        {
            this.getFebye();
            this.Ldangqian.Text = "1";
        }
        protected void LinkButton4_Click(object sender, EventArgs e) //尾页
        {
            int zongyeshu = Convert.ToInt32(this.YeCountL.Text.ToString().Trim());
            this.Ldangqian.Text = zongyeshu.ToString();
            int lastYecou = (zongyeshu - 1) * 10;

            string sql = string.Format("select top 10 * from Book where  xianshi='1' and id < (select min(id) from Book where id in (select top {0} id from Book where  xianshi='1' order by id desc )) order by id desc", lastYecou);
            DataTable dt = new DataTable();
            dt = database.GetSqlReturnDT(sql);

            this.DataList1.DataSource = dt;
            this.DataList1.DataBind();
        }

        protected void LBshang_Click(object sender, EventArgs e)  //上一页
        {
            int dangqianye = Convert.ToInt32(this.Ldangqian.Text.ToString().Trim());
            this.Ldangqian.Text = (dangqianye - 1) + "";
            int shangYeTiaoCou = (dangqianye - 1) * 10;

            string sql = string.Format("select * from Book where id in (select top 10 id from Book where  xianshi='1' and id >= ( select min(id) from Book where id in (select top {0} id from Book where  xianshi='1' order by id desc)))order by id desc", shangYeTiaoCou);
            DataTable dt = new DataTable();
            dt = database.GetSqlReturnDT(sql);

            this.DataList1.DataSource = dt;
            this.DataList1.DataBind();

        }
        protected void LBnext_Click(object sender, EventArgs e) //下一页
        {
            int dangqianye = Convert.ToInt32(this.Ldangqian.Text.ToString().Trim());
            this.Ldangqian.Text = (dangqianye + 1) + "";

            int dangqianTiaoCou = dangqianye * 10;

            string sql = string.Format("select top 10 * from Book where  xianshi='1' and id < (select min(id) from Book where id in (select top {0} id from Book where  xianshi='1' order by id desc )) order by id desc", dangqianTiaoCou);
            DataTable dt = new DataTable();
            dt = database.GetSqlReturnDT(sql);

            this.DataList1.DataSource = dt;
            this.DataList1.DataBind();

        }

#endregion