Charles Baldo
asked on
Need distinct values from dataset
Hello,
I have a data set that looks like the following
1,2,3,4
1,2,3,5
3,5,7,6
7,2,3,5
I wantt o get the distinct values from the middle 2 columns. So what I would like to see is this
2,3
5,7
It needs to be stored in a datset and then displayed in a datagrid.
Any help please
Thanks
Chuck
I have a data set that looks like the following
1,2,3,4
1,2,3,5
3,5,7,6
7,2,3,5
I wantt o get the distinct values from the middle 2 columns. So what I would like to see is this
2,3
5,7
It needs to be stored in a datset and then displayed in a datagrid.
Any help please
Thanks
Chuck
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was hoping to get an answer that said here is the dataset select distinct . However a microsft support answer is pretty difinitive. I have implemented the code.
Thanks again