Custom Paging in C#

[Maziar Aflatoun]

Hi,

I'm having problems with Custom Paging. Most of the articles out there show
that the custom paging is done as the following article.

http://authors.aspalliance.com/aspxt...tomPaging.aspx
(Check the example 'Custom Paging with AutoIncrement Data Model'). However,
the assumption here is that the rows are all there 1,2,3,4,5,6,7,8 but
that's not the case with many database tables. You can easily have deleted
rows and so get have rows such as 1,2,3,7,9 instead.

string query = "select top " + myGrid.PageSize +
" * from Plans where PlanNo > " + startIndex;
Any idea what a work around for this would be? or am I missing anything
here?

Thank you
Maziar A.

[Ravikanth[MVP]]

Please check the following article which describes how to design Custom Paging solution in asp.net datagri
http://www.ftponline.com/wss/2002%5F...s/architecting

HT
Ravikanth[MVP]

[Steve C. Orr [MVP, MCSD]]

Here's an interesting technique for datagrid paging that I recently read
about:
http://msdn.microsoft.com/msdnmag/is...e/default.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net

"Maziar Aflatoun" <ma***@rogers.com> wrote in message
news:Jm********************@news01.bloor.is.net.ca ble.rogers.com...

Hi,

I'm having problems with Custom Paging. Most of the articles out there show that the custom paging is done as the following article.

http://authors.aspalliance.com/aspxt...tomPaging.aspx (Check the example 'Custom Paging with AutoIncrement Data Model'). However, the assumption here is that the rows are all there 1,2,3,4,5,6,7,8 but
that's not the case with many database tables. You can easily have deleted
rows and so get have rows such as 1,2,3,7,9 instead.

string query = "select top " + myGrid.PageSize +
" * from Plans where PlanNo > " + startIndex;
Any idea what a work around for this would be? or am I missing anything
here?

Thank you
Maziar A.