Hello everyone,
I've studied samples, provided with Infragistics and read all relevant topics in knowledge base. I am still unable to find a solution for a following problem. I have around 30.000 + rows in data grid. I would like to load data of a detail view on demand (ie. whenever user expands master row, detail data are to be retrieved). So far i've been unsuccessful in achieving this. All samples are using data that read dataset prior to binding a dataset to grid. Is there any option to bind data only to specific band? (so each band would have its instance of datatable - i know this is a bit odd, but I assume that merging newly read data with grid's datasource - in my case dataset, would make things slower).
Does anyone have any suggestion on how to achieve this?
Best regards.
Hi,
I think the problem with something like this is the DataSource, not the grid. the grid has a LoadStyle which you can set to OnDemand, so the grid will only ask for the rows it needs. This would mean that the grid would not ask for child rows until you expand the parent row.
Unfortunately, the grid isn't really the issue, because a DataSet/DataTable in DotNet doesn't have any load-on-demand capability. The Million Rows sample included with the grid demonstrates using the UltraDataSource to load data on-demand, but it cheats in that it just loads random numbers. Where the actual data comes from is irrelvant as far as the grid is concerned.
So you might want to check around for some third-party data source object that can dynamically load data from the back-end on an an as-needed basis. I don't know of any, but I imagine there is probably something out there.