Hi --

I've used the Infragistics WinGrid before and had to set the MaxBandDepth property to prevent the grid from loading the entire database into memory.

Do you all know of a similar setting for the WebCombo control? (v 2005.2)

I did find the LoadOnDemand setting for WebGrid, but I don't seem to have access to that via the WebCombo.

(I know this is really an Infragistics specific question, but any ideas you all have would be appreciated.)

Thanks, -Ryan Casey

I'm not aware of that, sorry. You experience complete slow down and a lot of database activity when you open a page with the grid which is bound to a collection? (only in selfservicing)

The UltraWebCombo doesn't support multiple bands, so I think this cannot be the/an issue.

Otis wrote:

I'm not aware of that, sorry. You experience complete slow down and a lot of database activity when you open a page with the grid which is bound to a collection? (only in selfservicing)

Yep. (Sorry, forgot to mention I'm using selfservicing.)

BertS wrote:

The UltraWebCombo doesn't support multiple bands, so I think this cannot be the/an issue.

The reason why I thought that was the issue was that I started getting LLBL Gen exceptions about select permission denied errors on related tables. So, I suspect that it is loading related nodes.

After I corrected the permissions issue, the page just hangs more or less.

I also ran a SQL Trace to verify that it was indeed loading related tables, and there is a ton of activity.

Thanks, -Ryan Casey

Please contact Infragistics with this problem. Every O/R mapper with lazy loading suffers from this problem and they just should play nice with their stuff. If you need me to supply answers to their questions, just let me know.

Just FYI...

I have opened a case with Infragistics support. Their initial response was to use code to get the UltraWebGrid that is in the WebCombo and set the property for not "fetching" related objects using the grid.

Infragistics.WebUI.UltraWebGrid.UltraWebGrid uwg = (Infragistics.WebUI.UltraWebGrid.UltraWebGrid) this.WebCombo1.Controls(0);

uwg.Bands[0].ChildBandColumn = "NoChildBand";

This is supposed to work, but it does not work for me and I'm following up with them.

If I need some sample code from you all, I'll post a follow up or contact support.

Thanks.

No problem. Please let us know what the outcome is, preferably here on the forums so others can search on the result as well

If you need information from us to answer their questions, just post in this thread

The problem turned out to be the auto-generated code the Infragistics generated in the ASPX page for the columns and their properities. At some point I think the designer added all of the fields, including related objects/tables to the column list. When I removed all of the other columns from the ASPX page, the combo loads fine.

Thanks!