DataBoundGrid with relation

[Kai]

How do I NOT show the same rows in the grid when there is a self join relation in the dataset that the grid is bounding to?

[Administrator]

Hi Kai,

There is no built-in support for hide the duplicate record in a GridDataBoundGrid.The GridDataBoundGrid only displays what is presented to it by its DataSource.If you want to hide the duplicate record, then you need to implement your own support for hiding the duplicate record in a GridDataBoundGrid.Here is a code snippet for hide a Row/Reocrd

//Rows
this.grid.Model.Rows.Hidden[5] = true; //For hide the 5 th Row
this.grid.Model.Rows.Hidden[5] = false; //For show the 5 th Row

//get the record index using Binder
int RecordIndex = this.gridDataBoundGrid1.Binder.RowIndexToPosition(5)
this.grid.Model.Rows.Hidden[RecordIndex] = true;

Let us know if this helps.
Best Regards,
Haneef