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.
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.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mohan GopiPosted Sep 7, 2013, 2:27 AM
http://stackoverflow.com/questions/7109268/how-to-query-a-datatable-in-memory-to-fill-another-data-table
http://stackoverflow.com/questions/3829129/use-linq-to-group-data-from-datatable
i hope this will help you.
Thank's
Mohan G