Is this a bad way to page a datalist?

[needin4mation]

Is it a bad to page a datalist by using a dataadapter's fill method and
adjusting the int startRecord (in one of the overloads) as needed?

Example:

myAdap.Fill(myDS, index, 15, "contacts");

and changing the variable "index" as I need to? It would be 0 first,
then maybe 15 each time. index+=15 or index-=15? It seems to work so
far, but I do not know if it is "right." I am using SQL Server 2000 on
my host, so I cannot use ROWNUMBER(), afaik.

Thanks for advice.

 

[Swanand Mokashi]

Do you have an option to do the paging on the SQL Server side ??

Check out my article at
http://www.dotnetgenerics.com/Modules/TricksAndTips/SQLServer/DatabasePaging.aspx


--
Swanand Mokashi
Microsoft Certified Solution Developer (.NET) - Early Achiever
Microsoft Certified Application Developer (.NET)

http://www.dotnetgenerics.com/
DotNetGenerics.com -- anything and everything about Microsoft .NET
technology ...

http://www.swanandmokashi.com/
http://www.swanandmokashi.com/HomePage/WebServices/
Home of the Stock Quotes, Quote of the day and Horoscope web services