GridDropDownColumn DataSource queried every row

4 posts, 0 answers
  1. Craig Wallace
    Craig Wallace avatar
    118 posts
    Member since:
    Jan 2005

    Posted 06 Dec 2012 Link to this post

    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
  2. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 11 Dec 2012 Link to this post

    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.
  3. Gaetan
    Gaetan avatar
    8 posts
    Member since:
    May 2015

    Posted 09 Oct 2015 in reply to Maria Ilieva Link to this post

    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

  4. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 14 Oct 2015 Link to this post

    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
Back to Top