求一个分页的例子!(答完马上解帖!!!!!!)

Question

你是要帮你看代码还是要示例
示例的话，SDK文档中有现成的哦
ms-help://MS.VSCC/MS.MSDNVS.2052/cpguide/html/cpconpagingthroughqueryresult.htm

Answer 1

datagrid1.aspx:
...
<asp:datagrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 280px; POSITION: absolute; TOP: 144px" runat="server" AutoGenerateColumns="False" AllowPaging="True" PageSize="8" PagerStyle-Mode="NumericPages" OnPageIndexChanged="DataGrid1_PageIndexChanged">
<Columns>
<asp:BoundColumn DataField="UserName" HeaderText="用户名称"></asp:BoundColumn>
<asp:BoundColumn DataField="PhoneNum" HeaderText="手机号码"></asp:BoundColumn>
<asp:BoundColumn DataField="Email" HeaderText="默认Email"></asp:BoundColumn>
<asp:BoundColumn DataField="Fax" HeaderText="默认Fax"></asp:BoundColumn>
<asp:HyperLinkColumn Text="更新" DataNavigateUrlField="PhoneNum" DataNavigateUrlFormatString="RegisterUser.aspx?UserID={0}"></asp:HyperLinkColumn>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton ID="UDelBtn" CommandName="Delete" Runat="server" CssClass="DLink">删除</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<PagerStyle Mode="NumericPages" HorizontalAlign="Right" Position="Bottom" VerticalAlign="Bottom"></PagerStyle>
</asp:datagrid>
...
datagrid1.aspx.cs
...
protected void DataGrid1_PageIndexChanged(object source,DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
            UserBindBound();
}
...

Answer 2

说一说什么问题，看代码应该没什么问题的呀，把DataGrid的PageIndexChange事件关联到这个函数上了吗？

Answer 3

这是我用VB.NET在公司的一个项目中用的分页语句，希望对你有所帮助！   Private Sub DataGrid1_pageIndexChanged(ByVal sender As System.Object, ByVal e As DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
        DataGrid1.CurrentPageIndex = 0
        DataGrid1.CurrentPageIndex = e.NewPageIndex
        Dim strsql As String
        strsql = "select * from wd_inwh order by inid desc"
        Dim sdr As SqlDataAdapter = New SqlDataAdapter(strsql, conn)
        sdr.Fill(ds, "inwh")
        DataGrid1.DataSource = ds.tables("inwh").defaultview
        DataGrid1.DataBind()
    End Sub