Different data sources by querystring, very slow performance..

[Darren]

Hey folks,

I'm giving the radgrid a shot.  Basically when a user searches a different way, the page_load will direct it what data source to use like so:

If request.querystring("type") = "LocationCategory then
RadGrid1.datasource = sds_search_type_locationcategory
RadGrid1.DataBind()
End if

So i really have two questions. 

#1, is there a better way to do this? I have about 8 different 'types' of searches so the complexity is getting to be a little outrageous. Plus i have to use NeedsDatasource to allow paging/sorting etc which makes it more complex.

#2, Some of my queries return about 10,000 rows, is there a way to show the proper count but not select ALL of that data at once and only select it when its requested?

I cant be the only one out there doing something like this, hopefully i'll get some answers :)

[Shinu]

Hello Darren,

Please take a look at the following help article which explains the the grid performance optimization.
Client/server grid performance optimizations.

Thanks,
Shinu.