Sort Mutiple arrays in VB

Some good info in the first and last references but what I would like to do is sort the arrays themselves.

What version VB are you working in here?...

Visual Basic 2008 in VS2008

The String Arrays should sort just fine with xxx.Sort().

The ones with values won't sort properly if they are strings.  Are they declared as String arrays or Numeric Arrays?

Can you show the declarations?

The Ts() and Ps() arrays are both strings. There are only 4 different values to sort by in Ts() but there are 10 unique values in Ps(). I need them sorted by Ts() first and then Ps(). The sort order is not alphabetic order but is unique to the values in both Ts() and Ps().

Based on your example sort it looks more like it should sort by Ts() then Cs() because you posted this:

A                    Reg               2.50
A                    Mid                2.60
A                    Pre                2.73

The Ps() are not sorted before the Cs() as in:

A                    Mid                2.60
A                    Pre                2.73
A                    Reg               2.50

Why are you using separate arrays?  If you make a DataSet/DataTable out of the values then you can sort on multiple columns quite easily as Dhaest has shown in his links.

To sort multiple separate arrays you have to "sync" them and move the values in all three arrays as you sort...quite messy!

The values actually come into the application in a dataset but there is quite a bit of math that takes place to get the values in Cs(). Also three of the Ps() ,Cost() elements are used to create three additional Ps(),Cs() elements that do not exist in the original dataset. I would have loved to have had a singular dataset to manipulate but I could never come up with a simple and clean method to do so. I suppose I could eliminate all this array sorting by creating a new dataset/datatable after all the manipulation has taken place.

"I suppose I could eliminate all this array sorting by creating a new dataset/datatable after all the manipulation has taken place."

That would be my recommendation.

There isn't any built-in method to sort multiple arrays as "one unit" so you'd have to implement your own sorting algorithm and manually swap all the indexes in the related arrays to keep them in sync.

It's possible if you really want to see it.

I would love to see it if you could show me. I can't quite seem to get this one right.

if you are fetching data from sql server database then can fetch after manipulating the data. Means you can also do the manipulation at database side itself.

There is another way to fetch the data in datatable and perform sorting on it.

The original data is coming from sql-db but I am just learning how to use it. Other than creating tables and some simple procedures Im not sure how to accomplish this.

you don't want to use datatable??

I have accomplished the task by sorting the arrays. I think that had the code design been a little different futher upstream it would have made much more sense to do this via datatable. While the sorting method is Im certain not the most efficient, the number of values sorted is quite small and therefore has a negligable impact on performance.