Solved

Need distinct values from dataset

Posted on 2006-10-31
2
205 Views
Last Modified: 2010-04-16
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
0
Comment
Question by:Charles Baldo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
redpipe earned 500 total points
ID: 17845610
This support case from Microsoft should cover your issue with sample sourcecode and description:

HOW TO: Implement a DataSet SELECT DISTINCT Helper Class in Visual C# .NET
http://support.microsoft.com/kb/326176
0
 

Author Comment

by:Charles Baldo
ID: 17850387
Thanks redpipe.

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
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question