How can I make a Paging on DataReader?

  • Thread starter Thread starter Quentin Huo
  • Start date Start date
Q

Quentin Huo

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataSet paging vs Datareader paging 1
Datareader, dataset, else? 2
Binding a GridView Programmatically 1
Does DataBind close a datareader? 5
How to display a field value from a DataReader? 1
Iterating through specific rows of DataReader... 8
2008: Getting to title on Master Page 3
How can I fill array list with dataReader 1

Back
Top