How to use paging in asp.net through dataset for 100 or more records

[abhish_daga]

i use paging in ASP with recordset.pagesize property
but i dont no any property or otherway in dataset for paging in asp.net. if you have any idea then tell me.

thanks
abhishek

[juicemousezero]

What kind of database are you doing this with?

If you're on SQL server 2000 then it's a stupidly complicated process involving creating a temporary SQL table and a whole bunch of other crap. It's funny because in MySQL there's a LIMIT keyword that makes it very easy to do, but SQL server has no such keyword or equivalent. :confused:

[sirpelidor]

u can use paging feature off DataGrid or DataList. those 2 web controls are binding data off DataSet.