rpm
asked on
ASP.net skip the first three records of an SqlDataSource
Hi,
I have a form with a DataList bound to an SQLDataSource.
The first three records returned are showed in a different manner, so I want the DataList to show records 4 onwards.
How can I do this?
Thanks,
Richard
I have a form with a DataList bound to an SQLDataSource.
The first three records returned are showed in a different manner, so I want the DataList to show records 4 onwards.
How can I do this?
Thanks,
Richard
I think you will need to add some logic to your sql query to achieve that. Other option is to bind the list to a datatable which you can manipulate (delete first 3 rows).
The first three records returned are showed in a different mannerCould you please, give more detail?
ASKER
They are being shown separatly, so they should not appear in the DataList at all
You can also unbind the datalist and populate manually. After execute the statement(query) to populate a datatable you can set the datasource for the datalist as the datatable that you get with the first 3 rows deleted
Can you change the select statement?
You can add conditions in the where clause to make sql not to give those 3 records.
Try to send us some code and screenshots as files attached because is hard to guess what you want…
You can add conditions in the where clause to make sql not to give those 3 records.
Try to send us some code and screenshots as files attached because is hard to guess what you want…
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.