Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Neha
139
Remove duplicate rows
posted

Hi,

We are exporting our datagrid to excel and would like to remove duplicate rows before that.

Is there any way to do this?

 Thanks,

Neha.

Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    Hi Neha,

        There's nothing in the grid to do this for you.

        The approach I would take would be something like this: 

    • Trap the InitializeRow event of the UltraGridExcelExporter. 
    • Keep a hah table or a list of the grid rows that have already been added.
    • Each time the event fire, check the list to see if there is a row already in that list that matches the values in the current row. If so, set e.Hidden to true on the row - thus removing it from the export. 
Children