Groupby on Datatable with distinct count

Question

hi,

I have a datatable with some columns. I need the datatable to return the list as below.

Select col1, distinct count(col2) from table1 group by col1.

list of col1 and count of values of col2

Please let me know how to do this.

Thanks in advance.