使用asp.net C#和sql存储的procdure在数据列表中进行分页，例如Google分页 [英] Paging in Datalist like google paging using asp.net C# with sql stored procdure
问题描述
请帮助我紧急.
如何在Asp.Net中进行谷歌喜欢"分页?您只显示指向10个第一个搜索结果页面的链接，然后当我单击第10页时，会将另外10个页面添加到搜索结果中，等等.
我有一个典型的搜索表单和搜索结果列表.搜索结果页面可能很多.
通常，只有前几个搜索结果页面很有趣，但是必须也可以看到所有搜索结果.
我想做这样的事情:
1.首先查询前10个搜索结果页面
2.如果用户单击第10页，则会查询另外10个搜索结果页.
3.如果用户单击第20页，则会再次查询另外10个搜索结果页.
我不想一次性获取所有搜索结果，也不想获取所有搜索结果的数量.我只想获取下10个搜索结果页.
我正在使用数据集进行分页，但它不提供有效的分页，因此我想使用sql存储过程进行分页.
请包含演示，请提供给我.
谢谢buddy
Please Please Help me Its urgent.
How to do "google like" paging in Asp.Net? You only show links to 10 first search result pages, then when I click page 10, additional 10 more pages are added to search results etc.
I have a typical search form and list of search results. There are possibly many search result pages.
Typically only the first few search result pages are interesting and but it must be possible to also see all search results.
I''d like to do something like this:
1. Initially first 10 search result pages are queried
2. If user clicks page 10, additional 10 search result pages are queried.
3. If user clicks page 20, additional 10 search result pages are again queried.
I do not want to fetch all search results in one go, and I do not want to fetch number of all search results. I just want to fetch next 10 search result pages.
I am Doing paging with dataset but it not Provide the efficient paging so i want to paging with sql stored procedure.
Please if any contain demo Please provide me.
Thanks buddy
推荐答案
查看此信息 [ ^ ]
给定的链接可能会对您有所帮助.
Link1 -[使用T-SQL存储过程填充数据列表&数据列表自定义分页] [ Link2- [使用存储过程的数据列表分页] [
The given links might help you.
Link1-[Populating A Datalist Using A T-SQL Stored Procedure & Datalist Custom Paging][^]
Link2-[DataList paging using Stored Procedure][^]
至少您应该已经在CP中搜索过
SQL Server 2005分页结果 [在ASP.NET中对大型结果集进行分页 [使用ROW_NUMBER()分页GridView [使用ROWCOUNT和SQL_VARIANT进行SQL Server 2000分页和排序 [
At least you should have searched in CP
SQL Server 2005 Paging Results[^]
Paging of Large Resultsets in ASP.NET[^]
Paging GridView with ROW_NUMBER()[^]
SQL Server 2000 Paging and Sorting Using ROWCOUNT and SQL_VARIANT[^]
这篇关于使用asp.net C#和sql存储的procdure在数据列表中进行分页，例如Google分页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
