Hi,

I am testing your excellent product but I think there are issues with binding to Infragistic controls.

I have tried to bind a generated collectionclass to an Infragistics grid (Netadvantage 2005) All seemes to work except when I want to group in the infragistics grid.

Then I got system.stackOverfowException error. I got the error in the DAOclasses\PermModDAO.vb class on the line

Dim selectQuery As IRetrievalQuery = DynamicQueryEngine.CreateSelectDQ(fieldsToReturn, DbUtils.DetermineConnectionToUse(containingTransaction), _
                selectFilter, maxNumberOfItemsToReturn, sortClauses, relations, Not((Not(relations Is Nothing)) AndAlso (relations.Count > 0)), Nothing, pageNumber, pageSize)

Please is there any solution for this or is this an infragistics issue.

Besides the grid I do like the infragistics Controls in general.

I hope there is a solution.

Thanks

Geert

Please set the MaxBandDepth property of the grid to 1 (is default 100). This way you wont pull 100 levels deep of data from the db as infragistics grids don't play nice with ITypedList implementing collections (i.e.: it pulls the data from the property (which triggers lazy loading) instead of just work with the types.

Thanks for the quick response

I can not find MaxBandDepth property in this relaese of the grid. (Netadvantage 2005) However there is a loadondemand Property. I have triede to change it but nothing seems to work.

Anyone knows a solution with te latest build of the infragistics grid

Thanks

Geert

Geert wrote:

Thanks for the quick response

I can not find MaxBandDepth property in this relaese of the grid. (Netadvantage 2005) However there is a loadondemand Property. I have triede to change it but nothing seems to work.

Anyone knows a solution with te latest build of the infragistics grid

I don't have the 2005 release here, so I can't check for you.

Though you could switch to adapter, as that doesn't have lazy loading.

Thanks

I will check it out

Geert

Did anybody ever figure this out? I am having the same issue. Cannot switch to adapter at this point.

Geert wrote:

Thanks for the quick response

I can not find MaxBandDepth property in this relaese of the grid. (Netadvantage 2005) However there is a loadondemand Property. I have triede to change it but nothing seems to work.

Anyone knows a solution with te latest build of the infragistics grid

Thanks

Geert

Hi,

You can find the MaxBandDepth property inside the DisplayLayout property.

Hi,

You can find the MaxBandDepth property inside the DisplayLayout property.

I cannot find a MaxBandDepth property inside the DisplayLayout property (NetAdvantage 2005 r2). Nor could I find it in the object browser. Could this functionality have been removed or replaced?

Sam wrote:

Hi,

You can find the MaxBandDepth property inside the DisplayLayout property.

I cannot find a MaxBandDepth property inside the DisplayLayout property (NetAdvantage 2005 r2). Nor could I find it in the object browser. Could this functionality have been removed or replaced?

Hi,

I checked the UltraGid (2005 r2) and the MaxBandDepth property is there.

I have NetAdvantage 2005 v2 and you need to set the following code

ugGrid.DisplayLayout.MaxBandDepth = 1;

Geert wrote:

Hi,

I am testing your excellent product but I think there are issues with binding to Infragistic controls.

I have tried to bind a generated collectionclass to an Infragistics grid (Netadvantage 2005) All seemes to work except when I want to group in the infragistics grid.

Then I got system.stackOverfowException error. I got the error in the DAOclasses\PermModDAO.vb class on the line

Dim selectQuery As IRetrievalQuery = DynamicQueryEngine.CreateSelectDQ(fieldsToReturn, DbUtils.DetermineConnectionToUse(containingTransaction), _
                selectFilter, maxNumberOfItemsToReturn, sortClauses, relations, Not((Not(relations Is Nothing)) AndAlso (relations.Count > 0)), Nothing, pageNumber, pageSize)

Please is there any solution for this or is this an infragistics issue.

Besides the grid I do like the infragistics Controls in general.

I hope there is a solution.

Thanks

Geert

I checked the V2 webgrid and unable to find this property too.

Here is the code I have:

Dim oTemplateSet As New CrvlTemplatesSetEntity(cmbTemplateSet.SelectedValue.ToString)

Dim oTemplate As CrvlTemplatesCollection = oTemplateSet.GetMultiCrvlTemplatesCollectionViaCrvlTemplatesSetAssoc(True)



grdTemplate.DataSource = oTemplate.DefaultView
grdTemplate.DataBind()

Where grdTemplate = UltraWebGrid. When go to browse mode, after the grdTemplate.Databind() get executed, everything seem to go into a FROZEN STATE then I get err msg saying SERVER SEEM NOT TO RESPOND.

Be sure you've set the maxbanddepth (or whatever they call it now) to 1 instead of 100, otherwise the grid will pull the whole database into memory

Be sure to set the following

Bands(0).BaseTableName = "TABLE_NAME" grdTemplate.Bands(0).DataKeyField = "PKField"

I am able to get LLBLGen bind to infragistic webGrid fine now.