求带查询的分页功能

邦迪代驾 2010-11-18 09:48:56

小弟刚学NET，想用GridView做分页，带几个查询项，有哪位兄弟有源码的，给我一下，小弟感谢万分，QQ：1476845698

...全文

165 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

ycproc 2010-11-19

打赏
举报

dropdownlist 值改变动态加载数据

gudujianxiao 2010-11-19

打赏
举报

给一个GridView自带分页功能给你参考



<asp:GridView ID="gvSKUdetail" runat="server" AutoGenerateColumns="false" CssClass="gv"

            EnableViewState="true" AllowPaging="True" OnPageIndexChanging="gvSKUdetail_PageIndexChanging"

            PageSize="100" >

     

            <Columns>

                <asp:BoundField DataField="SKU" HeaderText="SKU" />

                <asp:BoundField DataField="Delta" HeaderText="变化量" NullDisplayText="N/A" />

                <asp:BoundField DataField="Balance" HeaderText="库存余额"  NullDisplayText="N/A" />

                <asp:BoundField DataField="UserName" HeaderText="操作人" />

                <asp:BoundField DataField="CreateDate" HeaderText="时间" />

                <asp:TemplateField HeaderText="类型">

                    <ItemTemplate>

                        <%# GetStockChangeType(Container.DataItem) %>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:BoundField DataField="Notes" HeaderText="备注" />

            </Columns>

            <PagerTemplate>

                <div style="text-align: right; color: Blue">

                    <asp:LinkButton ID="cmdFirstPage" runat="server" CommandName="Page" CommandArgument="First"

                        Enabled="<%# ((GridView)Container.Parent.Parent).PageIndex!=0 %>" >首页</asp:LinkButton>

                    <asp:LinkButton ID="cmdPreview" runat="server" CommandArgument="Prev" CommandName="Page"

                    

                        Enabled="<%# ((GridView)Container.Parent.Parent).PageIndex!=0 %>" >上页</asp:LinkButton>

                    第<asp:Label ID="lblcurPage" ForeColor="Blue" runat="server" Text='<%# ((GridView)Container.Parent.Parent).PageIndex+1  %>'></asp:Label>页/共<asp:Label

                        ID="lblPageCount" ForeColor="blue" runat="server" Text='<%# ((GridView)Container.Parent.Parent).PageCount %>'></asp:Label>页

                    <asp:LinkButton ID="cmdNext" runat="server" CommandName="Page" CommandArgument="Next"

                        Enabled="<%# ((GridView)Container.Parent.Parent).PageIndex!=((GridView)Container.Parent.Parent).PageCount-1 %>" >下页</asp:LinkButton>

                    <asp:LinkButton ID="cmdLastPage" runat="server" CommandArgument="Last" CommandName="Page"

                        Enabled="<%# ((GridView)Container.Parent.Parent).PageIndex!=((GridView)Container.Parent.Parent).PageCount-1 %>" >尾页</asp:LinkButton>

                     

                    <asp:TextBox ID="txtGoPage" runat="server" Text='<%# ((GridView)Container.Parent.Parent).PageIndex+1 %>'

                        Width="32px" ></asp:TextBox>页<asp:Button ID="btnGo" runat="server" CommandArgument="X"

                            OnClick="Go_Click" Text="转到" /> </div>

            </PagerTemplate>

        </asp:GridView>

后台



   protected void Go_Click(object sender, EventArgs e)

        {

            //判断是否是非法的字符

            int PageIndex=0;

            if (!Utilities.IsNumber(((TextBox)gvSKUdetail.BottomPagerRow.FindControl("txtGoPage")).Text))

            {

                PageIndex =0;

            }

            else

             PageIndex= int.Parse(((TextBox)gvSKUdetail.BottomPagerRow.FindControl("txtGoPage")).Text) - 1;

//绑定数据到GridView

    Bind();

        }

        protected void gvSKUdetail_PageIndexChanging(object sender, GridViewPageEventArgs e)

        {

            gvSKUdetail.PageIndex = e.NewPageIndex;

                //绑定数据到GridView

    Bind();

 

        }