Hi,

I generated the code for my web application with SelfServecing type and if i bind my grid (Syncfusion Grid) with Collection data, the query is executing in-definately and OutOfMemeoryException is raising. Here is the sample code. LoadDetailsCollection (_loadDetails) is my collection object to bind to the grid. GridGroupingControl1.DataSource = _loadDetails; GridGroupingControl1.DataMember = "Load_Details"; GridGroupingControl1.DataBind();

The same data if i bind to the asp.net grid it's working fine. What colud be the problem? Can anyone help on this?

tamma wrote:

Hi,

I generated the code for my web application with SelfServecing type and if i bind my grid (Syncfusion Grid) with Collection data, the query is executing in-definately and OutOfMemeoryException is raising. Here is the sample code. LoadDetailsCollection (_loadDetails) is my collection object to bind to the grid. GridGroupingControl1.DataSource = _loadDetails; GridGroupingControl1.DataMember = "Load_Details"; GridGroupingControl1.DataBind();

The same data if i bind to the asp.net grid it's working fine. What colud be the problem? Can anyone help on this?

Does your grid have an option to stop it looking for child collections? What may be happening is that the lazy-loading is being invoked by the grid as it looks for child collections to display - you may end up loading the whole DB!

Cheers Simon

tamma wrote:

Hi,

I generated the code for my web application with SelfServecing type and if i bind my grid (Syncfusion Grid) with Collection data, the query is executing in-definately and OutOfMemeoryException is raising. Here is the sample code. LoadDetailsCollection (_loadDetails) is my collection object to bind to the grid. GridGroupingControl1.DataSource = _loadDetails; GridGroupingControl1.DataMember = "Load_Details"; GridGroupingControl1.DataBind();

The same data if i bind to the asp.net grid it's working fine. What colud be the problem? Can anyone help on this?

Another thing - what is the "Load_Details" DataMember for? That would normally look for a child property/relationship to bind to of that name but I suspect you just need to bind to the DataSource itself - try not setting it at all or setting it to "".

Cheers Simon

I tried of removing DataMember value. There is no property to access the child tables properties to stop the Db calls.

Hello,

do you have a property to define the hierchical level of your grid? How do you fetch your collection, do you have any prefetch path?

I indeed think it's caused by the fact that Syncfusion's grid doesn't use any standard interface but simply reads the data from the properties, which triggers lazy loading.

The only way to stop this, is either by contacting syncfusion and demand a fix, or perhaps through a property of their grid which defines a max-band depth like the infragistics grids have

I resolved of this issue, it is happening due to relations. It is working for (1:n, m:1), but if i add m:n relation to my loading table then it's going to call query indefinitely.