Self serving, asp.net 2, latest build of V2.

I know that if I have a gridview based on a llblgenprodatasource and want to be able to sort on a field on related field, I have to set the datasource control to client side sorting. However, I also need the paging control set on the datasource as there are thousands of records. This means obviously that only one page gets sorted. Is there a way around this?

Darren

Did you try to set paging on gridview by setting the property AllowPaging to True instead of using paging on llblgenprodatasource ?

Yes but due to the number of records, it is a lot slower.

I was hoping that when you have fields on related fields the SQL would generate inner joins with sorting and paging.

Does anybody have a standard way of dealing with this? (I want to edit the table in a codeless manner so I am using an entity collection and a datasource)

Darren

What type of relation do you have between your collection being used for your grid and the entity containing the field you want to sort on?

You could sort on the db by setting the sortexpression on the datasourcecontrol. The paging on the client sorts indeed the data in the control, as it doesn't have all the data on the client (obviously, why else would you want to use paging ).