求带查询的分页功能

Question

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

Answer 1

自带分页比较。如果是datalist 就用控件做select查询条数分页吧

Answer 2

http://topic.csdn.net/u/20101116/13/77d2270a-a5ae-4001-87be-db7ad02c04ae.html
你去看一下吧

Answer 3

给一个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>
                    &nbsp;
                    <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="转到" />&nbsp;</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();
 
        }

Answer 4

dropdownlist  值改变 动态加载  数据