8 Answers, 1 is accepted
0
![](/forums/images/avatarimages/39919b70-532f-465f-8efd-7edb2fc108a71.jpg)
Shinu
Top achievements
Rank 2
answered on 08 Jan 2009, 06:01 AM
Hi Staron,
Please refer following link to online documentation. I hope this will help you in configuring "GridDropDownColumn".
Customize/Configure GridDropDownColumn
Thanks,
Shinu.
Please refer following link to online documentation. I hope this will help you in configuring "GridDropDownColumn".
Customize/Configure GridDropDownColumn
Thanks,
Shinu.
0
![](/forums/images/avatarimages/default.gif)
staron
Top achievements
Rank 1
answered on 08 Jan 2009, 09:05 AM
Hi,
Thanks for your reply. I have read this prior to my post, but it does not say anything about our main issue. Namely that the column queries the db on load, and then again when you enter edit mode. Is there a way to prevent this?
Thanks for your reply. I have read this prior to my post, but it does not say anything about our main issue. Namely that the column queries the db on load, and then again when you enter edit mode. Is there a way to prevent this?
0
![](/forums/images/avatarimages/default.gif)
staron
Top achievements
Rank 1
answered on 08 Jan 2009, 11:15 AM
Done a bit more research and the dropdowncolumn does one query for each grid row also. This is unacceptible as this will kill performance on large grids.
0
Hi staron,
Indeed if you have very large number of items in the dropdown editor, this may cause a performance penalty when using built-in GridDropDownColumn. In such cases you may consider placing RadComboBox inside template grid column and utilize its load on demand mechanism as shown in the example from the knowledge base article linked below:
http://www.telerik.com/support/kb/aspnet-ajax/combobox/using-radcombobox-with-autocomplete-as-a-custom-editor-in-radgrid.aspx
Best regards,
Sebastian
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Indeed if you have very large number of items in the dropdown editor, this may cause a performance penalty when using built-in GridDropDownColumn. In such cases you may consider placing RadComboBox inside template grid column and utilize its load on demand mechanism as shown in the example from the knowledge base article linked below:
http://www.telerik.com/support/kb/aspnet-ajax/combobox/using-radcombobox-with-autocomplete-as-a-custom-editor-in-radgrid.aspx
Best regards,
Sebastian
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
![](/forums/images/avatarimages/default.gif)
staron
Top achievements
Rank 1
answered on 08 Jan 2009, 12:52 PM
Hi,
This doesn't really solve my issue. Take this scenario. My grid has 10 rows, when grid is loading its data, it first gets these 10 rows from db. Then it makes one call for each row to the combobox datasource. Thus it makes 11 db calls just to load!
I need a way to prevent the combobox from making a db call until its data is actually needed, when it goes into editmode...
Hope you can help as this is rather urgent.
This doesn't really solve my issue. Take this scenario. My grid has 10 rows, when grid is loading its data, it first gets these 10 rows from db. Then it makes one call for each row to the combobox datasource. Thus it makes 11 db calls just to load!
I need a way to prevent the combobox from making a db call until its data is actually needed, when it goes into editmode...
Hope you can help as this is rather urgent.
0
Hello staron,
In the sample project from the kb article the items in the comboboxes should be generated on demand only when you start typing in it or open the dropdown. Let me know if I am missing something obvious.
Best regards,
Sebastian
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
In the sample project from the kb article the items in the comboboxes should be generated on demand only when you start typing in it or open the dropdown. Let me know if I am missing something obvious.
Best regards,
Sebastian
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
![](/forums/images/avatarimages/default.gif)
staron
Top achievements
Rank 1
answered on 08 Jan 2009, 01:16 PM
I appologize, I was a bit hasty there. I got it working now, thank you. Is there any plans on adding the loadondemand property to the dropdown column in the future?
0
Hi staron,
Thank you for your suggestion. I will forward your request to our development department for further consideration. If this appears to be a common request and an attainable enhancement, you may see it included in a future version of the product
Best regards,
Rosen
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Thank you for your suggestion. I will forward your request to our development department for further consideration. If this appears to be a common request and an attainable enhancement, you may see it included in a future version of the product
Best regards,
Rosen
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.