GridDropDownColumn DataSource queried every row

[Craig Wallace]

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

[Maria Ilieva]

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

[Gaetan]

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

[Maria Ilieva]

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