J
Jim H
I am storing incoming data in memory using a DataTable. After I'm done
retrieving the data I need to get the distinct rows. I tried using
DataTable.Select but that doesn't work.
If I have columns "col1", "col2", "col3" in my DataTable "Table1", I need to
basically be able to do this:
select distinct col2 form Table1
I tried doing this:
DataRow[] ResultsRowArray = MyTable.Select("distinct col2");
This obviously does not work. How can I get back an array of distinct rows?
I don't care if it all 3 columns or just that one.
BTW I am not connected to any databases. I don't need to store the data
like that permanently.
Thanks,
jim
retrieving the data I need to get the distinct rows. I tried using
DataTable.Select but that doesn't work.
If I have columns "col1", "col2", "col3" in my DataTable "Table1", I need to
basically be able to do this:
select distinct col2 form Table1
I tried doing this:
DataRow[] ResultsRowArray = MyTable.Select("distinct col2");
This obviously does not work. How can I get back an array of distinct rows?
I don't care if it all 3 columns or just that one.
BTW I am not connected to any databases. I don't need to store the data
like that permanently.
Thanks,
jim