473,407 Members | 2,676 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

How can I make a Paging on DataReader?

Hi,

There is a page in my project which is just to list the all article titles
by paging (20 titles per page). So I think it might be more efficient using
SqlDataReader instead of DataSet. But How can I make paging on DataReader?
Can I do this? If yes, can you show me a short example?

Thanks

Q.
Nov 18 '05 #1
2 3024
The datareader itslef does not support paging (to my knowledge.)

However, you can write SQL commands that handle paging.
Do a Google search of Paging to see manydifferent ways to do it.
--
Joe Fallon

"Quentin Huo" <q.***@manyworlds.com> wrote in message
news:OV*************@TK2MSFTNGP12.phx.gbl...
Hi,

There is a page in my project which is just to list the all article titles
by paging (20 titles per page). So I think it might be more efficient using SqlDataReader instead of DataSet. But How can I make paging on DataReader?
Can I do this? If yes, can you show me a short example?

Thanks

Q.

Nov 18 '05 #2
The datareader itslef does not support paging (to my knowledge.)

However, you can write SQL commands that handle paging.
Do a Google search of Paging to see manydifferent ways to do it.
--
Joe Fallon

"Quentin Huo" <q.***@manyworlds.com> wrote in message
news:OV*************@TK2MSFTNGP12.phx.gbl...
Hi,

There is a page in my project which is just to list the all article titles
by paging (20 titles per page). So I think it might be more efficient using SqlDataReader instead of DataSet. But How can I make paging on DataReader?
Can I do this? If yes, can you show me a short example?

Thanks

Q.

Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Jo | last post by:
Hi, I am using a OleDB provider that connects to ANY datasource - I do not know if these have some nice ID that I can page on. Using the OleDataAdapter FILL method. I then fill the dataset...
2
by: Jeremy Ames | last post by:
Is there a way to setup paging with a data reader? For instance, I only want 10 records at a time, and I can move through the next ten when I need them. From the members that I saw listed in the MSDN...
1
by: Paul Hobbs | last post by:
Hi Everyone, I am trying to implement a DataGrid that uses Custom paging, but the DataSource is a SQLDataReader, not a DataSet. I have seen examples that use the Fill method of a DataAdapter to...
1
by: Joseph D. DeJohn | last post by:
Hello, I'm trying to implement custom paging. At the moment I can get the first page to display. When I click on the number 2 it takes forever to come back to the Page_Load function. I am...
1
by: Quentin Huo | last post by:
Hi, There is a page in my project which is just to list the all article titles by paging (20 titles per page). So I think it might be more efficient using SqlDataReader instead of DataSet. But...
1
by: Patrick.O.Ige | last post by:
I have been paging with DataSet using "DataGridPageChangedEventArgs" and i guess it works with only Dataset because default paging requires that the DataGrid be able to determine the number of...
3
by: Darren | last post by:
Dear Groups I've used paging with a datagrid in C# at least a hundred times, but for whatever reason, I cannot get the prev /next to appear as links. It is absolutely certain that the number of...
6
by: Natan Vivo | last post by:
I had to built a custom data paging control for my asp.net app and SQL Server. This is what I'm doing: 1. do a SELECT to a SqlDataReader 2. create a DataTable with data from GetSchema() 3....
3
by: nyhetsgrupper | last post by:
Hi everyone, In a datagrid the entire data is read but only the page you want is displayed to the user when you enable paging. Does the Gridview control works in the same way? So if you have...
2
by: jaredciagar | last post by:
Hi Guys, Please Help ME.... I have a problem in displaying data in my gridview with paging, the data from the database is displaying to my gridview but I want to allow paging in my gridview.how can...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.