我想要一个完整的可以翻页显示的DataGrid的源码,谢谢. (C#)

<%@ Import Namespace="System.Data" %><html>
<script language="C#" runat="server">    ICollection CreateDataSource() {
        DataTable dt = new DataTable();
        DataRow dr;        dt.Columns.Add(new DataColumn("IntegerValue", typeof(Int32)));
        dt.Columns.Add(new DataColumn("StringValue", typeof(string)));
        dt.Columns.Add(new DataColumn("DateTimeValue", typeof(string)));
        dt.Columns.Add(new DataColumn("BoolValue", typeof(bool)));        for (int i = 0; i < 200; i++) {
            dr = dt.NewRow();            dr[0] = i;
            dr[1] = "Item " + i.ToString();
            dr[2] = DateTime.Now.ToShortDateString();
            dr[3] = (i % 2 != 0) ? true : false;            dt.Rows.Add(dr);
        }        DataView dv = new DataView(dt);
        return dv;
    }    void Page_Load(Object sender, EventArgs e) {
        if (chk1.Checked) {
            MyDataGrid.PagerStyle.Mode=PagerMode.NumericPages;
        }
        else {
            MyDataGrid.PagerStyle.Mode=PagerMode.NextPrev;
        }        BindGrid();
    }    void MyDataGrid_Page(Object sender, DataGridPageChangedEventArgs e) {
        MyDataGrid.CurrentPageIndex = e.NewPageIndex;        BindGrid();
    }    void BindGrid() {
        MyDataGrid.DataSource = CreateDataSource();
        MyDataGrid.DataBind();
        ShowStats();
    }    void ShowStats() {
        lblCurrentIndex.Text = "CurrentPageIndex is " + MyDataGrid.CurrentPageIndex;
        lblPageCount.Text = "PageCount is " + MyDataGrid.PageCount;
    }
</script><body>    <h3><font face="Verdana">Basic Paging with DataGrid</font></h3>    <form runat=server>      <ASP:DataGrid id="MyDataGrid" runat="server"
        AllowPaging="True"
        PageSize="10"
        PagerStyle-Mode="NumericPages"
        PagerStyle-HorizontalAlign="Right"
        PagerStyle-NextPageText="Next"
        PagerStyle-PrevPageText="Prev"
        OnPageIndexChanged="MyDataGrid_Page"
        BorderColor="black"
        BorderWidth="1"
        GridLines="Both"
        CellPadding="3"
        CellSpacing="0"
        Font-Name="Verdana"
        Font-Size="8pt"
        HeaderStyle-BackColor="#aaaadd"
        AlternatingItemStyle-BackColor="#eeeeee"
        />      <p>
      <asp:Checkbox id="chk1" runat="server"
        Text="Show numeric page navigation buttons"
        Font-Name="Verdana"
        Font-Size="8pt"
        AutoPostBack="true"
        />      <p>
      <table bgcolor="#eeeeee" cellpadding="6"><tr><td nowrap><font face="Verdana" size="-2">        <asp:Label id="lblCurrentIndex" runat="server" /><br>
        <asp:Label id="lblPageCount" runat="server" /><br>      </font></td></tr></table>
  </form></body>
</html>

解决方案 »

  1.   

    你用VS.NET创建一个DataGrid分页看看就行啦,大同小异而已
      

  2.   

    <asp:datagrid id="myGrid" Runat="server" AllowPaging="True" PageSize="5">……</asp:datagrid>private void myGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
    {
    myGrid.CurrentPageIndex = e.NewPageIndex;
    myGrid.DataBind();
    }
      

  3.   


    private void ControlGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
    {
    ControlGrid.CurrentPageIndex=e.NewPageIndex;
    BindGrid();
    }
    private void BindGrid()
    {
    ...
    }
      

  4.   

    能不能把第一个改成SQL SERVER数据的,谢谢.
      

  5.   

    我在使用DataGrid时直接在属性生成器中设置分页行为为什么不好用呀？
      

  6.   

    <%@ Page Language="vb" Debug="true" %>
    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.sqlclient" %>
    <html>
    <script language="VB" runat="server">
    Sub Page_Load(sender As Object, E As EventArgs)
        If chk1.Checked Then
            MyDataGrid.PagerStyle.Mode = PagerMode.NumericPages
        Else
            MyDataGrid.PagerStyle.Mode = PagerMode.NextPrev
        End If 
        BindGrid()
    End Sub 'Page_LoadSub MyDataGrid_Page(sender As Object, e As DataGridPageChangedEventArgs)
        MyDataGrid.CurrentPageIndex = e.NewPageIndex
        BindGrid()
    End Sub 'MyDataGrid_PageSub BindGrid()
        dim mydbconn as SQLConnection
        mydbconn=new SQLConnection("server=10.1.31.90;uid=sa;pwd=haoziahaozia;database=mybook")
        Dim DS As DataSet
        Dim MyCommand As SqlDataAdapter
        MyCommand = new SqlDataAdapter("select * from userinfo", Mydbconn)
        DS = new DataSet()
        MyCommand.Fill(DS, "userinfo")
        MyDataGrid.DataSource=DS.Tables("userinfo").DefaultView
        MyDataGrid.DataBind()
    End Sub 'BindGridSub ShowStats()
        lblEnabled.Text = "AllowPaging is " & MyDataGrid.AllowPaging
        lblCurrentIndex.Text = "CurrentPageIndex is " & MyDataGrid.CurrentPageIndex
        lblPageCount.Text = "PageCount is " & MyDataGrid.PageCount
        lblPageSize.Text = "PageSize is " & MyDataGrid.PageSize
    End Sub 'ShowStats
     
     
     </script>
     
     <body>
     
        <h3>DataGrid Paging Example</h3>
     
        <form runat=server>
     
           <asp:DataGrid id="MyDataGrid" runat="server"
                AllowPaging="True"
                PageSize="10"
        width="700"
                OnPageIndexChanged="MyDataGrid_Page"
                BorderColor="black"
                BorderWidth="1"
                GridLines="Both"
                CellPadding="3"
                CellSpacing="0"
                Font-Name="Verdana"
                Font-Size="9pt">
              <PagerStyle Mode="NumericPages"
                          HorizontalAlign="Right">
              </PagerStyle>
              <HeaderStyle BackColor="#aaaadd">
              </HeaderStyle>
              <AlternatingItemStyle BackColor="#eeeeee">
              </AlternatingItemStyle> 
           </asp:DataGrid>       
           <p>
           <asp:Checkbox id="chk1" runat="server"
                Text="Show numeric page navigation buttons"
                Font-Name="Verdana"
                Font-Size="8pt"
                AutoPostBack="true"/>
           <p>
           <table bgcolor="#eeeeee" cellpadding="6">
              <tr>
                 <td nowrap> 
                       <asp:Label id="lblEnabled" runat="server"/><br>
                       <asp:Label id="lblCurrentIndex" runat="server"/><br>
                       <asp:Label id="lblPageCount" runat="server"/><br>
                       <asp:Label id="lblPageSize" runat="server"/><br>
                 </td>
              </tr>
           </table>
        </form>
     </body>
     </html>