数据绑定 分页控件

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

 

void BindGV()
    {

        string strqry = "select * from jy_sb where jy=" + DropDownList1.SelectedItem.Value + " order by id desc";
        DataSet ds = new DataSet();

        using (SqlConnection conn = new SqlConnection(cn))
        {
            SqlDataAdapter dr = new SqlDataAdapter(strqry, conn);

            dr.Fill(ds);
        }


        AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
        PagedDataSource pds = new PagedDataSource();
        pds.AllowPaging = true;
        pds.PageSize = AspNetPager1.PageSize;
        pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
        pds.DataSource = ds.Tables[0].DefaultView;

        GridView1.DataSource = pds;
        GridView1.DataBind();
    }


 protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        BindGV();
    }

 

 

 

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"  
                AllowSorting="True" OnRowCommand="GridView1_RowCommand" BackColor="White" 
                BorderColor="#E5F3F8" BorderStyle="None" BorderWidth="1px" CellPadding="4" 
                Width="100%" style=" margin-top:-3px" CellSpacing="1" 
                GridLines="None">
                <Columns>
                    <asp:TemplateField HeaderText="名称">
                        <ItemTemplate >
                        <span style="text-align:left; padding-left:10px; float:left"><%# Eval("nam") %></span>
                           
                        </ItemTemplate>
                        <HeaderStyle HorizontalAlign="Left" CssClass="kkkkk"/>
                    </asp:TemplateField>
                    
                    <asp:BoundField DataField="tim" HeaderText="时间" >
                        <ItemStyle HorizontalAlign="Center" />
                    </asp:BoundField>
                    <asp:TemplateField HeaderText="操作">
                    <ItemTemplate>
                        <asp:LinkButton ID="LinkButton1" runat="server" CommandName="ed" CommandArgument='<%# Eval("id") %>'>修改</asp:LinkButton>
                        <asp:LinkButton ID="LinkButton2" runat="server" CommandName="del" CommandArgument='<%# Eval("id") %>' OnClientClick="return confirm('确定删除')">删除</asp:LinkButton>
                    </ItemTemplate>
                        <ItemStyle HorizontalAlign="Center" />
                    </asp:TemplateField>
                </Columns>
                <RowStyle Height="20px" BackColor="#E5F3F8" BorderStyle="None" BorderWidth="1px" />
                
                <HeaderStyle BackColor="#E5F3F8" Height="20px"/>
</asp:GridView>

 

<asp:DataList ID="DataList1" runat="server" Font-Size="X-Small" GridLines="Both" RepeatColumns="3" RepeatDirection="Horizontal">
<ItemTemplate>
<table style="font-size:12px; width:100%; margin:0 auto">
<tr align="center">
<td><img src='../upimg/<%# Eval("img") %>' id="img" style="border:1px solid black; width:130px; height:96px;" alt='<%#  Eval("nam") %>' /></td>
</tr>
<tr align="center" valign="middle">
<td><a href='show4.aspx?id=<%# Eval("id") %>'> <%# new xhc().zfjq( Eval("nam").ToString(),30) %></a></td>
</tr>
</table>   
</ItemTemplate>         
<HeaderStyle BackColor="Gray" />
</asp:DataList>


<asp:Repeater ID="Repeater2" runat="server">
<ItemTemplate>
<tr>
<td Class="ClassNews"><img src="../Images/top.jpg" border="0" align="absmiddle"> <a href='show.aspx?id=<%#Eval("id") %>' target="_blank" title='<%# Eval("nam") %>'><%# new xhc().zfjq(Eval("nam").ToString(),50) %></a> (<%# new xhc().jqsj((DateTime)Eval("tim")) %>)</td>
</tr>
</ItemTemplate>
<HeaderTemplate>
<table width="100%">
</HeaderTemplate>
<FooterTemplate></table></FooterTemplate>
</asp:Repeater>

 

 

<table width="100%" style="margin-top:-3px;">
<tr bgcolor="#F7F7F7">
<td style=" text-align:left; padding-left:10px;height:30px"><webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="True" CustomInfoHTML="<font color='red'>%RecordCount%</font>条记录 每页<font color='red'>%PageSize%</font>记录 当前<font color='red'>%CurrentPageIndex%/%PageCount%</font>页"CustomInfoStyle="FONT-SIZE: 12px" FirstPageText="首页" HorizontalAlign="Right"  InputBoxStyle="width:19px" LastPageText="尾页" meta:resourcekey="AspNetPager1"
            NextPageText="下一页" OnPageChanged="AspNetPager1_PageChanged" PrevPageText="上一页"
            ShowCustomInfoSection="Left" Style="font-size: 12px" Width="100%" 
                    EnableUrlRewriting="True">
        </webdiyer:AspNetPager> 
                 </td>          
             </tr> 
         </table>