DataGrid自动分页的问题

Txxiaoqiang 2009-01-09 06:12:48

为什么分页不管用？我查询出来的数据是对的，是两页，运行程序是只显示一页，下面也没有显示是两页。用的是vs2005 和accesss数据库



前台代码：

<asp:DataGrid ID="dgSpread" runat="server" AllowPaging="True" AutoGenerateColumns="False"

                            PageSize="2" CssClass="DbGridStyle" Width="100%" OnPageIndexChanged="dgSpread_PageIndexChanged" AllowCustomPaging="True">

                            <ItemStyle CssClass="ItemStyle"></ItemStyle>

                            <HeaderStyle CssClass="GridHeadStyle"></HeaderStyle>

                            <SelectedItemStyle CssClass="SelectedItemStyle" />

                            <PagerStyle HorizontalAlign="Left" CssClass="GridPagerStyle" Mode="NumericPages"></PagerStyle>

                            <Columns>

                                <asp:TemplateColumn HeaderText="纽扣编码">

                                    <HeaderStyle Width="7%"></HeaderStyle>

                                    <ItemStyle HorizontalAlign="Left"></ItemStyle>

                                    <ItemTemplate>

                                        <asp:HyperLink ID="hyperLinkStat" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "CommodityCode")%>'

                                            NavigateUrl='<%# "NKAdd.aspx?CommodityCode="+DataBinder.Eval(Container.DataItem,"CommodityCode")+"&strJudage=1"%>'>

                                        </asp:HyperLink>

                                    </ItemTemplate>

                                </asp:TemplateColumn>

                                <asp:BoundColumn DataField="CommodityName" HeaderText="纽扣名称" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="ShortName" HeaderText="纽扣简称" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="FirstCategoryID" HeaderText="一级类别" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="SecondCategoryID" HeaderText="二级类别" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="ThirdCategoryID" HeaderText="三级类别" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="FourthCategoryID" HeaderText="四级类别" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="FifthCategoryID" HeaderText="五级类别" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="sstyle" HeaderText="规格型号" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="Color" HeaderText="纽扣颜色" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="cwhcode" HeaderText="仓库编码" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="cposcode" HeaderText="货位编码" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="Unit" HeaderText="计量单位" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="InPrice" HeaderText="采购单价" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="OutPrice" HeaderText="销售单价" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="cMaker" HeaderText="录入人" ReadOnly="True"></asp:BoundColumn>

                                <asp:BoundColumn DataField="cMakerdate" HeaderText="录入日期" ReadOnly="True"></asp:BoundColumn>

                            </Columns>

                        </asp:DataGrid>







后台代码

 protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            Bind(0);

        }

    }

    

    public void Bind(int index)

    {

        string sql = "SELECT a.CommodityCode, a.CommodityName, a.ShortName, a.sstyle, a.Color, a.cwhcode, " +

      " a.cposcode, a.Unit, a.cMemo, a.cMaker, a.cMakerdate, a.OutPrice, a.KcOnline, " +

      " a.KcOffline, a.FirstCategoryID, a.SecondCategoryID, a.ThirdCategoryID, " +

      " a.FourthCategoryID, a.FifthCategoryID, a.InPrice" +

      " FROM (((((tb_Commodity a INNER JOIN" +

      " tb_NKCategory b ON a.FirstCategoryID = b.CategoryID) LEFT OUTER JOIN " +

      " tb_NKCategory c ON a.SecondCategoryID = c.CategoryID) LEFT OUTER JOIN " +

      " tb_NKCategory d ON a.ThirdCategoryID = d.CategoryID) LEFT OUTER JOIN " +

      " tb_NKCategory e ON a.FourthCategoryID = e.CategoryID) LEFT OUTER JOIN " +

      " tb_NKCategory F ON a.FifthCategoryID = F.CategoryID)";

        function ft = new function();

        DataTable dt = ft.GetDataTable(sql);

        if (dt.Rows.Count > dgSpread.PageSize)

        {

            dgSpread.AllowCustomPaging = true;

        }

        else

        {

            dgSpread.AllowCustomPaging = false;

        }

        dgSpread.CurrentPageIndex = index;

        dgSpread.DataSource = dt;

        dgSpread.DataBind();

    }





    protected void dgSpread_PageIndexChanged(object source, DataGridPageChangedEventArgs e)

    {

        Bind(e.NewPageIndex);

    }