The TableView component has a method ToTable which will do this.

http://help.openspan.com/80/Components/Data_Table_Viewer.htm

Hi, can anyone provide detailed step on this? I'm new to DataGrid/DataTable/TableView.

Thanks

Hi ,

    You can use the following code to get the distinct values. Hope this helps.

var distinctIds = dt.AsEnumerable()

                    .Select(s=> new {

                        id = s.Field<string>("YourColumnName"),                           

                     })

                    .Distinct().ToList();

foreach(object o in distinctIds)

{

    Type t = o.GetType();

    PropertyInfo[] pi = t.GetProperties();

    foreach (PropertyInfo p in pi)

    {

        //Here you will get distinct value for your given column.

        MessageBox.Show(p.GetValue(o).ToString());

    }

}