How to filter distinct records from a normal Select query and display in a web control
"Select distinct <field> from <table>".This SELECT statement is used to filter out duplicate results from a query’s output. But sometimes the requirement is to use a Stored Procedure which returns the entire data and display the manipulated distinct data in web server control.
To do this use SortedList
For using SortedList import namespace System.Collections