Eliminate Duplicate Values from the Grid View

Hi Akhil,
Thanks for  u r reply.
But I'm not getting output from that reference.
It will eliminate all columns from top to bottom.
Any other suggestion is their for my problem ?

You can do it through datatable just iterate through each cell and if the data is repeating delete that data from cell. and after that you can bind.


or you can copy data to another table and check conditions.


3rd way just sort it through appno then type, then dept and that remove the duplicate data.
http://www.c-sharpcorner.com/UploadFile/31514f/sorting-and-filtering-in-data-table/