This is a migrated thread and some comments may be shown as answers.

GridDropDownColumn DataSource queried every row

3 Answers 29 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Craig Wallace
Top achievements
Rank 1
Craig Wallace asked on 06 Dec 2012, 11:36 AM
Hi,

I have put together a nice, codeless, RadGrid, which uses a GridDropDownColumn bound to an EntityDataSource for one of the columns. This works well, except that it seemed a bit slow to render the page.  Upon checking SQL Server, I can see that the EntityDataSource that the GridDropDownColumn is bound to is running its select statement for every single row that is displayed in the RadGrid :(

Is there any way round this or is the GridDropDownColumn essentially unusable in the real world?

Thanks,

Craig

3 Answers, 1 is accepted

Sort by
0
Maria Ilieva
Telerik team
answered on 11 Dec 2012, 12:47 PM
Hello Craig,

Better approach in this case would be to use GridTemplateColumn with a RadComboBox control bind with LoadOnDemand. This will significantly decrease the load time and will be better option in performance matter.

Kind regards,
Maria Ilieva
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Gaetan
Top achievements
Rank 1
answered on 09 Oct 2015, 09:30 AM

Hello Maria

I have a grid with a programmatically generated GridDropDownColumn which runs horribly slow (only few items in the list, so it's not about loading too much data)...

I guess in that siutation, the template column is not something to consider, because I generate columns dynamicaly, right?

What would be a good solution for that scenario?

 

thanks,

 

Gaetan

0
Maria Ilieva
Telerik team
answered on 14 Oct 2015, 07:52 AM
Hi Gaetan,

Try setting the DropDownControl Type to "RadComboBox" and see how it goes. If this does not help , it will be best if you could share your page markup as well as related code behind so that we can revise your structure and advise you further.

Regards,
Maria Ilieva
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Grid
Asked by
Craig Wallace
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Gaetan
Top achievements
Rank 1
Share this question
or