GridView自定义分页

< asp:GridView ID = " GridView1 "  runat = " server "  OnPageIndexChanging = " GridView1_PageIndexChanging "
        AutoGenerateColumns
= " False "   AllowPaging = " True "  PageSize = " 5 "  DataKeyNames = " uid "    >
        
< Columns >
    
< asp:TemplateField HeaderText = " 名称 "  SortExpression = " uname " >
                                
< EditItemTemplate >
                                    
< asp:TextBox ID = " TextBox1 "  runat = " server "  Text = ' <%# Bind("uname") %> ' ></ asp:TextBox >
                                
</ EditItemTemplate >
                                
< ItemTemplate >
                                
<% # DataBinder.Eval(Container.DataItem,  " uname " ) %></ a >
                                
</ ItemTemplate >
                            
</ asp:TemplateField >   
                    
< asp:TemplateField HeaderText = " 年龄 "  SortExpression = " uname " >
                        
< EditItemTemplate >
                            
< asp:TextBox ID = " txtAge "  runat = " server "  Text = ' <%# Bind("age") %> ' ></ asp:TextBox >
                       
                        
</ EditItemTemplate >
                        
< ItemTemplate >
                            
< asp:Label ID = " Label2 "  runat = " server "  Text = ' <%# Bind("age") %> ' ></ asp:Label >
                        
</ ItemTemplate >
                    
</ asp:TemplateField >
                    
< asp:TemplateField HeaderText = " 性别 "  SortExpression = " sex " >
                        
< EditItemTemplate >
                            
< asp:TextBox ID = " txtSex "  runat = " server "  Text = ' <%# Bind("sex") %> ' ></ asp:TextBox >
                       
                        
</ EditItemTemplate >
                        
< ItemTemplate >
                            
< asp:Label ID = " Label3 "  runat = " server "  Text = ' <%# Bind("sex") %> ' ></ asp:Label >
                        
</ ItemTemplate >
                    
</ asp:TemplateField >
                   
</ Columns >
        
</ asp:GridView >
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="前一页" />
        <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="后一页" />
        <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="最后一页" />
        <asp:Button ID="Button4" runat="server" OnClick="Button4_Click" Text="第一页" />

 后台代码:

 

  public   void  GridViewDataBind()
    
{
        Button1.Enabled 
= true;
        Button2.Enabled 
= true;
       
        
try
        
{
            
            SqlDataAdapter da 
= new SqlDataAdapter("select * from test", conn);
            DataSet ds 
= new DataSet();
            da.Fill(ds, 
"customers");
            
if (ds.Tables[0].Rows.Count == 0)
            
{
                AddDummyData(ds);
            }

            GridView1.DataSource 
= ds.Tables["customers"];
            GridView1.AllowPaging 
= true;
            GridView1.PageSize 
= 5;
            GridView1.DataBind();

            
if (GridView1.PageIndex == 0)
            
{
                Button1.Enabled 
= false;
            }

            
if (GridView1.PageIndex == GridView1.PageCount - 1)
            
{
                Button2.Enabled 
= false;
            }


        }

        
catch(Exception ex)
        
{
            ex.ToString();
        }


    }

    
protected   void  GridView1_PageIndexChanging( object  sender, GridViewPageEventArgs e)
    
{
        GridView1.PageIndex 
= e.NewPageIndex;
        GridViewDataBind();
    }

    
protected   void  Button1_Click( object  sender, EventArgs e)
    
{
        GridView1.PageIndex 
= GridView1.PageIndex - 1;
        GridViewDataBind();
    }

    
protected   void  Button2_Click( object  sender, EventArgs e)
    
{
        GridView1.PageIndex 
= GridView1.PageIndex + 1;
        GridViewDataBind();
    }

    
protected   void  Button3_Click( object  sender, EventArgs e)
    
{
        GridView1.PageIndex 
= GridView1.PageCount - 1;
        GridViewDataBind();
    }

    
protected   void  Button4_Click( object  sender, EventArgs e)
    
{
        GridView1.PageIndex 
= 0;
        GridViewDataBind();
    }

    
private   void  AddDummyData(DataSet ds)
    
{

        
//如果没有数据显示空行

        DataTable dt 
= ds.Tables[0];

        DataRow newRow 
= dt.NewRow();

        dt.Rows.Add(newRow);

    }

    
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值