hi

i want to implement paging , i m not using DataGrid instead using HTML table and datareader.

can anyone there guide me how to implement paging in this scenario

waiting for reply

A datareader doesn't implement an ICollection interface so you can't use it. You have to use a DataTable.

I just read that you can use a DataReader with custom paging. Sorry for the confusion.

In case the term "custom paging" hasn't helped yet, here's an article that explains custom paging:

http://www.devhood.com/tutorials/tut...tutorial_id=97

Cheers,

Imar

stu9820 ,I'm not sure he could come back(I mean going previous page) while using DataReader.

--------------------------------------------
Mehdi.:)

You can use a DataReader for a repeating control (such as a datagrid, datalist, repeater, etc). When you involve paging of a datagrid, you STILL can use a DataReader. Remember that we are dealing with a stateless paradigm here: ASP.NET. When you rebind a datagrid or another object to go to another page of data, you are usually refreshing the entire data source anyway and starting from the beginning, then you are going to the particular page of data you wish to see. In the case of a datagrid, it does all that for you. In the case of custom paging (for a datagrid or some handmade repeating scenario), you must write the code (usually the sql query) that accesses the particular "page" you wish to see. But in either case, you are still only using a forward-only data source (the datareader). So when you go "back" a page you are technically only going forward n-1 pages from where you were (n).

I think its time-consuming,using SP(sql queries)could be better.
Thanks to Peter.

--------------------------------------------
Mehdi.:)

What is time-consuming? You have to "page" the data somewhere. It's just a matter of where you do it. If you want to perform optimization to the extreme, then yes, you should write queries that page the data and use custom paging. There's little point in transporting data that you don't use. If your database server is not the same physical machine as your web server then you definately could increase performance that way.

I ment something you mentioned
peter can you explain more this you mentioned
do you mean they are something like Sequential files against Random(Direct)files
i.e in a Sequential file for getting a record you must read all previous records
but in Random Files you can access a record directly
did you mean like I told




--------------------------------------------
Mehdi.:)

hi

i want to implement paging using asp.Net, i m not using datagrid repeator control etc.
i m just using html table and datareader.
i want just 10 rows to be displayed per page , how i do this