Which collection to use?

Question

0.00/5 (No votes)

See more:

Once again my self-taught VB.NET skills leave me not knowing the best way to proceed. Hopefully one of you more knowledgeable than me will be able to offer a suggestion.

I have some data that has 4 fields:

Name, PointNumber,  X,     Y
Test1,   10,      345623, 457890
Test1,   20,      345633, 457910
Test1,   30,      345622, 457930
Test1,   40,      345699, 457910
Test1,   50,      345750, 458001
Test32,  100,     345623, 757890
Test32,  200,     345659, 757800
etc.........

I want to be able to sort on the Name, and then these in turn by the PointNumber. Finally I want to be able to linearly interpolate on the pointNumber, so if I have a known Name (say 'Test1') I can calculate what X an Y would be at PointNumber 22.56 etc.

Ignoring the actual interpolation, can anyone suggest what would be the best collection to use to do this?

Perhaps a Sorted List of Key Value pairs? Or perhaps a customised class / property?

Thanks for any suggestions !

Posted 13-May-14 0:03am

codetowns

Updated 13-May-14 0:10am

Nelek

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Accepted Answer · 2014-05-13T00:18:00

Solution 1

You could create a class, say MyPoint for encapsulating your four fields and then use a List(Of MyPoint). You may then sort it using your own comparer, see List(Of T).Sort Method (IComparer(Of T))[^].

Posted 13-May-14 0:18am

CPallini

Comments

codetowns 17-May-14 11:06am

Many thanks - two good ideas !

OriginalGriff · Accepted Answer · 2014-05-13T00:20:00

Solution 2

Me? I'd create a class holding the four properties, and use a generic List.
Then you can sort with Linq methods:

VB

Dim sorted = myList.OrderBy(Function(m) m.Name).ThenBy(Function(m) m.PointNumber)

Posted 13-May-14 0:20am

OriginalGriff

Comments

codetowns 17-May-14 11:06am

Many thanks - two good ideas !