Link to home
Start Free TrialLog in
Avatar of KaranGupta
KaranGupta

asked on

dataset query

How does u get record no from 5 to 15 from a dataset of 100 records
ASKER CERTIFIED SOLUTION
Avatar of owaisyahya
owaisyahya

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
what is your db? if it is sql server add a new column

row_number() over (order by some columns here) rn

now yor dataset will have a new column named rn, which you can use filter

ds.defaultview.rowfilter="rn between 5 and 15"

http://msdn.microsoft.com/en-us/library/system.data.dataview.rowfilter(v=vs.71).aspx