Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Need distinct values from dataset

Posted on 2006-10-31
2
Medium Priority
?
208 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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

609 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