急！用DataGrid怎么分页？

Question

一直不太懂！
哪位大侠能讲一下
或者
给点源码看看
我希望有CS和ASPX的代码，简单但要完整或能运行！！！
谢谢诸位！！！

Answer 1

选择DataGrid ,右键选择"属性生成器",在"分页"里设置分页属性

Answer 2

<asp:datagrid id="grid1" runat="server" PagerStyle-PageButtonCount="20" PagerStyle-Mode="NumericPages"  CellPadding="3" GridLines="None" AllowPaging="True" PageSize="13"
...><PagerStyle HorizontalAlign="Right" Mode="NumericPages" PageButtonCount="10" BackColor="#F8F8F8"></PagerStyle>
</asp:datagrid>
CS:private void grid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
this.dgrid.CurrentPageIndex=e.NewPageIndex;
                           bindData();//重新查询绑定 }

Answer 3

this.dgrid.CurrentPageIndex=e.NewPageIndex;

Answer 4

控制一下CurrentPageIndex等几个属性的值就可以了

Answer 5

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
this.DataGrid1.DataBind();
}
当然还要在属性生成器里面设置允许分页什么的

Answer 6

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex=e.NewPageIndex; 
SetBind(); 
}

Answer 7

机器里的MSDN中有,自己把代码贴到IDE里试下就好了

Answer 8

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Drawing.Imaging;
using System.Drawing.Design;
public partial class DataGridTest2 : System.Web.UI.Page
{
    private string constring;
    private SqlDataAdapter sa; 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        { 
           DataGridDataBind();
           GridViewDataBind();
        }
            
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (DataGrid1.Columns[0].Visible == true)
        {
            DataGrid1.Columns[0].Visible = false;
            Button1.Text = "显示";        }
        else
        {
            DataGrid1.Columns[0].Visible = true;
            Button1.Text = "隐藏";
        }
        
    }
    private int sum = 0;
    protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemIndex != -1)
        {
            int orderID = e.Item.ItemIndex + 1;
            e.Item.Cells[0].Text = orderID.ToString();
        }
       if (e.Item.ItemIndex >= 0)
        { 
             sum += int.Parse(e.Item.Cells[2].Text);      
        }
        else if(e.Item.ItemType == ListItemType.Footer)
        {
             e.Item.Cells[1].Text ="总和";
             e.Item.Cells[2].Text =sum.ToString();
        }
        if (e.Item.Cells[0].Text == "11")
            e.Item.BackColor = System.Drawing.Color.Blue;        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            e.Item.Attributes.Add("onmouseover","currentcolor=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");
        }
        showstats();
    }
    private void DataGridDataBind()
    {
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["constr"].ToString());
        SqlDataAdapter sa = new SqlDataAdapter("select fname,job_lvl,hire_date from employee", conn);
        DataSet ds = new DataSet();
        try
        {
            sa.Fill(ds, "tb1");
            DataGrid1.DataSource = ds;
            DataGrid1.DataBind();
        }
        catch (Exception error)
        {
            Response.Write(error.ToString());
        }
    }    private void GridViewDataBind()
    {
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["constr"].ToString());
       // SqlDataAdapter sa = new SqlDataAdapter("select fname,job_lvl,hire_date from employee", conn);
       
         SqlDataAdapter sa = new SqlDataAdapter(" exec myproc", conn);
        DataSet ds = new DataSet();
        try
        {
            sa.Fill(ds, "tb1");
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
        catch (Exception error)
        {
            Response.Write(error.ToString());
        }
    }    protected void DataGrid1_SelectedIndexChanged(object sender, EventArgs e)
    {    }    private void showstats()
    {
        cindex.Text = "第 " + (DataGrid1.CurrentPageIndex + 1).ToString() + "页";
        Pcount.Text = "总共" + DataGrid1.PageCount.ToString() + "页";
    }    protected void PagerButtonClick(object sender, EventArgs e)
    {
        string arg = ((LinkButton)sender).CommandArgument.ToString();
        switch (arg)
        {
            case "prev":
                if (DataGrid1.CurrentPageIndex > 0)
                {
                    DataGrid1.CurrentPageIndex -= 1;
                } break;
            case "next":
                if (DataGrid1.CurrentPageIndex < DataGrid1.PageCount - 1)
                {
                    DataGrid1.CurrentPageIndex += 1;
                } break;
            case "last":
                DataGrid1.CurrentPageIndex = DataGrid1.PageCount - 1; break;
            default:
                DataGrid1.CurrentPageIndex = System.Convert.ToInt32(arg);break;
        }
        DataGridDataBind();
        showstats();
    }    protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        DataGridDataBind();
        showstats();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Class1 s = new Class1();
        Label1.Text = s.hello();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        if (GridView1.EditIndex != -1)
        {
            // Use the Cancel property to cancel the paging operation.
            e.Cancel = true;            // Display an error message.
            int newPageNumber = e.NewPageIndex + 1;
            Message.Text = "Please update the record before moving to page " +
              newPageNumber.ToString() + ".";
        }
        else
        {
            // Clear the error message.
            Message.Text = "";
        }    }
    void DisplayCurrentPage()
    {
        // Calculate the current page number.
        int currentPage = GridView1.PageIndex + 1;        // Display the current page number. 
        Message.Text = "Page " + currentPage.ToString() + " of " +
          GridView1.PageCount.ToString() + ".";
        GridViewDataBind();
    }    protected void GridView1_PageIndexChanged(object sender, EventArgs e)
    {
       DisplayCurrentPage();
    }
}

Answer 9

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DataGridTest2.aspx.cs" Inherits="DataGridTest2" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        &nbsp; &nbsp;
        <asp:DataGrid ID="DataGrid1" runat="server" BackColor="White" BorderColor="#E7E7FF"
            BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal" Height="279px"
            Width="346px" AutoGenerateColumns="False" OnItemDataBound="DataGrid1_ItemDataBound" OnSelectedIndexChanged="DataGrid1_SelectedIndexChanged" AllowPaging="True" OnPageIndexChanged="DataGrid1_PageIndexChanged" ShowFooter="True">
            <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
            <SelectedItemStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
            <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" Mode="NumericPages" />
            <AlternatingItemStyle BackColor="#F7F7F7" />
            <ItemStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
            <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
            <Columns>
                <asp:BoundColumn HeaderText="编号"></asp:BoundColumn>
                <asp:BoundColumn DataField="fname" HeaderText="姓名"></asp:BoundColumn>
                <asp:BoundColumn DataField="job_lvl" HeaderText="工作总量"></asp:BoundColumn>
                <asp:BoundColumn DataField="hire_date" DataFormatString="{0:d}" HeaderText="雇佣时间"></asp:BoundColumn>
            </Columns>
        </asp:DataGrid>
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
        &nbsp;
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="隐藏" />
        &nbsp;&nbsp;
        <asp:LinkButton ID="LinkButton4" runat="server" OnClick="PagerButtonClick" CommandArgument="0">最首页</asp:LinkButton>
        <asp:LinkButton ID="LinkButton3" runat="server" OnClick="PagerButtonClick" CommandArgument="prev">前一页</asp:LinkButton>
        <asp:LinkButton ID="LinkButton2" runat="server" OnClick="PagerButtonClick" CommandArgument="next">下一页</asp:LinkButton>
        <asp:LinkButton ID="LinkButton1" runat="server" OnClick="PagerButtonClick" CommandArgument="last">最后页</asp:LinkButton>&nbsp;
        <asp:Label ID="cindex" runat="server" BorderStyle="None"></asp:Label>&nbsp;
        <asp:DataList ID="DataList1" runat="server" BackColor="White" BorderColor="#3366CC"
            BorderStyle="None" BorderWidth="1px" CellPadding="4" GridLines="Both" Width="300px">
            <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
            <SelectedItemStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
            <ItemTemplate>
                gdfgdfgdfg
            </ItemTemplate>
            <AlternatingItemTemplate>
                dfgdfgdfg
            </AlternatingItemTemplate>
            <EditItemTemplate>
                dfgdfgd
            </EditItemTemplate>
            <ItemStyle BackColor="White" ForeColor="#003399" />
            <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
            <SelectedItemTemplate>
                dfgdfgdfg
            </SelectedItemTemplate>
            <HeaderTemplate>
                头模板
            </HeaderTemplate>
            <SeparatorTemplate>
            </SeparatorTemplate>
            <FooterTemplate>
                尾模板
            </FooterTemplate>
        </asp:DataList>&nbsp;
        <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="Button" />
        <asp:Label ID="Pcount" runat="server" Text="Label" Width="173px"></asp:Label>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" OnPageIndexChanged="GridView1_PageIndexChanged" OnPageIndexChanging="GridView1_PageIndexChanging">
        </asp:GridView>
        <asp:Label ID="Message" runat="server"></asp:Label>
        <asp:Label ID="Label2" runat="server" Text="Label" Width="142px"></asp:Label>
        <asp:DataList ID="DataList2" runat="server" CellPadding="4" ForeColor="#333333" RepeatColumns="2">
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <AlternatingItemStyle BackColor="White" />
            <ItemStyle BackColor="#EFF3FB" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        </asp:DataList></div>
    </form>
</body>
</html>

Answer 10

以上的代码还要在Web.conf中加入
<appSettings>
<add key="constr" value="server=(local);Database=pubs;User id=sa;Pwd=''"></add>
</appSettings>

Answer 11

在单文件模型中写:必须在属性生成器里面给设置一下分页:下面的才能实现 CS:private void grid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
this.dgrid.CurrentPageIndex=e.NewPageIndex;
                           bindData();//重新查询绑定 }

Answer 12

<%@ Page Language="VB" AutoEventWireup="True" Debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %><html>
   <script runat="server">
     dim MyConnection as OleDbConnection      Sub Page_Load(sender As Object, e As EventArgs) 
      MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath(".")+"/db/data.mdb")         If Not IsPostBack Then 
            BindGrid()
         End If
      End Sub      Sub MyDataGrid_Page(sender as Object, e As DataGridPageChangedEventArgs) 
          MyDataGrid.CurrentPageIndex = e.NewPageIndex
          BindGrid()
      End Sub      Sub BindGrid() 
      Dim MyCommand As OleDbDataAdapter = new OleDbDataAdapter("select * from [min]", MyConnection)
          Dim DS As DataSet = new DataSet()
          MyCommand.Fill(DS,"min") 
          MyDataGrid.DataSource = DS.Tables("min").DefaultView
          MyDataGrid.DataBind()
      End Sub
</script>
<form runat="server">
    <asp:DataGrid id="MyDataGrid" 
           AllowPaging="True" 
           PageSize="5" 
           OnPageIndexChanged="MyDataGrid_Page" 
           runat="server"
   AutoGenerateColumns="False"
   Width="200">
         <HeaderStyle BackColor="Navy" 
                      ForeColor="White" 
                      Font-Bold="True" 
  HorizontalAlign="Center"/>
         <PagerStyle Mode="NextPrev"
                     HorizontalAlign="Right" 
 NextPageText="下一页"
                     PrevPageText="上一页"/>
      <Columns>
         <asp:BoundColumn DataField="id" HeaderText="ID"/>
 <asp:TemplateColumn HeaderText="zhuti">
<ItemTemplate>
        <asp:Label ID="lblTotalPrice"  Text='<%#(Container.DataItem("zhuti"))%>' Runat=server />
</ItemTemplate> 
</asp:TemplateColumn> 
      </Columns>
      </asp:DataGrid>
</form>