To clarify things, are you saying there are 30 to 40 DetailGrids for every master rows, or 30 to 40 DetailGrids for the whole master grid?
If you mean the first option, this means 2.7 million rows minimum ( 30k records X 30 DetailGrids X 3 detail rows ).
In this case, since the grid does not offer a virtual mode (loading data on the fly as needed), the only option you have is to implement your own data paging (that is, make your data source give only the rows you need to display, and request rows as needed), or use idle time in your application to load records into the DataSet, which means the grid will added them automatically, and eventually, all records will be loaded.
Imported from legacy forums. Posted by André (had 1178 views)