Home Forums WinForms controls Xceed Grid for WinForms Master Detail & Sub Detail Grid Reply To: Master Detail & Sub Detail Grid

User (Old forums)
Member
Post count: 23064

Hi,

 I’m using the same logic to display the master detail data. But there’s an issue, it is taking too long(more than 3 minutes) to display the data. Actually, my master table have approximately 30k records and there are 30-40 detailed grids with 3 or 4 records on an average. When I debug the code masterGridControl.UpdateDetailGrids()  is taking almost all the time. Is there any other way to optimise my code?? your advise is highly appreciated.

Following is my code…….

tmsDataSet.Relations.Add(“Rel_Sample”, xxDataSet.masterTable.IdColumn,

xxDataSet.detailTable.IdColumn, false);

masterGridControl.BeginInit();

masterGridControl.SynchronizeDetailGrids =

true;

masterGridControl.SetDataBinding(xxDataSet, “masterTable”);

DetailGrid detGrid = new DetailGrid();

detGrid.SetDataBinding(xxDataSet,

“masterTable.Rel_Sample”);

InitialiseDetailGrid(detGrid ,

“masterTable”);

masterGridControl.DetailGridTemplates.Add(detGrid);

masterGridControl.UpdateDetailGrids();

masterGridControl.EndInit();

 

Imported from legacy forums. Posted by Ram (had 379 views)