Solved

vb.net - put dataset records into array

Posted on 2009-04-06
2
543 Views
Last Modified: 2012-05-06
Table has these columns and multipe rows. Name is PK.

Name , Price , number1 , number2 , number 3

What would the vb.net code look like if I wanted to put "unique" values of number1, number2 and number3 into an array where price=2? and then sort this array from smallest to largest. Important thing is to have unique values.

Anyone?
0
Comment
Question by:ralphcarter2008
2 Comments
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
ID: 24084533
I think that you should take a look at the transpose-method in the article (transposes means that you put rows into columns ...)

http://www.eggheadcafe.com/tutorials/aspnet/5c5d810e-20e6-4d6c-a0a3-5277ba8de7e7/transpose-a-datatable-in.aspx
0
 
LVL 1

Author Closing Comment

by:ralphcarter2008
ID: 31567352
Thanks
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

809 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