Link to home
Start Free TrialLog in
Avatar of rpm
rpmFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

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).
Avatar of TI2Heaven
TI2Heaven

The first three records returned are showed in a different manner
Could you please, give more detail?
Avatar of rpm

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…
ASKER CERTIFIED SOLUTION
Avatar of Alan Warren
Alan Warren
Flag of Philippines image

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