使用asp.net C#和sql存储的程序在数据列表中进行分页，例如Google分页 [英] Paging in Datalist like google paging using asp.net C# and sql stored procdure
问题描述
我是asp.net的新手Plz帮我它紧急.
如何在Asp.Net中进行谷歌喜欢"分页?您只显示指向10个第一个搜索结果页面的链接，然后当我单击第10页时，会将另外10个页面添加到搜索结果中，等等.
我有一个典型的搜索表单和搜索结果列表.搜索结果页面可能很多.
通常，只有前几个搜索结果页面很有趣，但是必须也可以看到所有搜索结果.
我想做这样的事情:
1.首先查询前10个搜索结果页面
2.如果用户单击第10页，则会查询另外10个搜索结果页.
3.如果用户单击第20页，则会再次查询另外10个搜索结果页.
我不想一次性获取所有搜索结果，也不想获取所有搜索结果的数量.我只想获取下10个搜索结果页.
我正在使用数据集进行分页，但它不提供有效的分页，所以我想使用sql存储过程进行分页.
Hi I am New in asp.net Plz 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 am want to paging with sql stored procedure.
推荐答案
这 [
Hi,
Check this[^]
And this[^]
最初查询的前10个搜索结果页面
您只需传递开始和结束行号即可从数据库中仅提取10条记录.
SQL SERVER-2005 T-SQL分页查询技术比较(OVER和ROW_NUMBER())-CTE与派生表 [^ ]
http://www.beansoftware.com/ASP.NET-Tutorials/SQL-Queries- Paging.aspx [ ^ ]
Initially first 10 search result pages are queried
You have to pull only 10 records from the database by passing the the start and ending row number.
SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table[^]
http://www.beansoftware.com/ASP.NET-Tutorials/SQL-Queries-Paging.aspx[^]
此链接正是您想要的内容.它以友好的seo方式分页Google之类的数据列表.
http://weblogs. asp.net/stanly/archive/2011/05/03/custom-seo-friendly-paging-in-datalist-like-google.aspx [
This link provides exactly what you want.It is paging a datalist like google in a friendly seo way.
http://weblogs.asp.net/stanly/archive/2011/05/03/custom-seo-friendly-paging-in-datalist-like-google.aspx[^]
Good luck !.
这篇关于使用asp.net C#和sql存储的程序在数据列表中进行分页，例如Google分页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
