472,805 Members | 860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

Array.sort question

Let's say I have a class of people...

Public Class People
Public Sex as String
Public Age as int
Public Name as string
end class

And I declare an array of this class...

Dim MyPeopleArray(3) as People

Then I fill my arry with 3 people...

MyPeopleArray(0).Sex = "Female"
MyPeopleArray(0).Age = 32
MyPeopleArray(0).Name = "Marsha Marsha Marsha"

MyPeopleArray(1).Sex = "Male"
MyPeopleArray(1).Age = 31
MyPeopleArray(1).Name = "John"

MyPeopleArray(2).Sex = "Can't decide"
MyPeopleArray(2).Age = "23"
MyPeopleArray(2).Name = "Don't lable me"

How would I resort my the MyPeopleArray to have the people in Age order,
name order or sex order?

Thanks!

Jim

Jul 19 '05 #1
4 3530
Jim,
Define a PeopleComparer class that implements the IComparer interface. The
PeopleComparer object would know which property you want to sort on and act
accordingly.

When you call Array.Sort, you would use the overloaded version that accepts
an IComparer.

For an example see:
http://msdn.microsoft.com/library/de...SortTopic3.asp

I would define the PeopleComparer to accept the property name as a parameter
to the constructor then have a select case in the compare.

Something like:

Public Class PeopleComparer
Implements IComparer

Private Readonly m_field As String

Public Sub New()
MyClass.New("Name")
End Sub

Public Sub New(ByVal field As String)
m_field = field
End Sub

Public Function Compare(ByVal x As Object, ByVal y As Object) As
Integer _
Implements IComparer.Compare
Dim xo As People = DirectCast(x, People)
Dim yo As People = DirectCast(y, People)
Select Case m_field
Case "Sex"
Return xo.Sex.CompareTo(yo.Sex)
Case "Age"
Return xo.Age.CompareTo(yo.Age)
Case "Name"
Return xo.Name.CompareTo(yo.Name)
End Select
End Function

End Class
Array.Sort(MyPeopleArray, New PeopleComparer("Age"))

Hope this helps
Jay

"its me" <at**@house.com> wrote in message
news:4s*****************@fe02.atl2.webusenet.com.. .
Let's say I have a class of people...

Public Class People
Public Sex as String
Public Age as int
Public Name as string
end class

And I declare an array of this class...

Dim MyPeopleArray(3) as People

Then I fill my arry with 3 people...

MyPeopleArray(0).Sex = "Female"
MyPeopleArray(0).Age = 32
MyPeopleArray(0).Name = "Marsha Marsha Marsha"

MyPeopleArray(1).Sex = "Male"
MyPeopleArray(1).Age = 31
MyPeopleArray(1).Name = "John"

MyPeopleArray(2).Sex = "Can't decide"
MyPeopleArray(2).Age = "23"
MyPeopleArray(2).Name = "Don't lable me"

How would I resort my the MyPeopleArray to have the people in Age order,
name order or sex order?

Thanks!

Jim

Jul 19 '05 #2

"Jay B. Harlow [MVP - Outlook]" <Ja********@email.msn.com> wrote in message
news:ur**************@TK2MSFTNGP10.phx.gbl...
Jim,
Define a PeopleComparer class that implements the IComparer interface. The
PeopleComparer object would know which property you want to sort on and act accordingly.

When you call Array.Sort, you would use the overloaded version that accepts an IComparer.

For an example see:
http://msdn.microsoft.com/library/de...SortTopic3.asp
I would define the PeopleComparer to accept the property name as a parameter to the constructor then have a select case in the compare.

Something like:

Public Class PeopleComparer
Implements IComparer

Private Readonly m_field As String

Public Sub New()
MyClass.New("Name")
End Sub

Public Sub New(ByVal field As String)
m_field = field
End Sub

Public Function Compare(ByVal x As Object, ByVal y As Object) As
Integer _
Implements IComparer.Compare
Dim xo As People = DirectCast(x, People)
Dim yo As People = DirectCast(y, People)
Select Case m_field
Case "Sex"
Return xo.Sex.CompareTo(yo.Sex)
Case "Age"
Return xo.Age.CompareTo(yo.Age)
Case "Name"
Return xo.Name.CompareTo(yo.Name)
End Select
End Function

End Class
Array.Sort(MyPeopleArray, New PeopleComparer("Age"))

Hope this helps
Jay

"its me" <at**@house.com> wrote in message
news:4s*****************@fe02.atl2.webusenet.com.. .
Let's say I have a class of people...

Public Class People
Public Sex as String
Public Age as int
Public Name as string
end class

And I declare an array of this class...

Dim MyPeopleArray(3) as People

Then I fill my arry with 3 people...

MyPeopleArray(0).Sex = "Female"
MyPeopleArray(0).Age = 32
MyPeopleArray(0).Name = "Marsha Marsha Marsha"

MyPeopleArray(1).Sex = "Male"
MyPeopleArray(1).Age = 31
MyPeopleArray(1).Name = "John"

MyPeopleArray(2).Sex = "Can't decide"
MyPeopleArray(2).Age = "23"
MyPeopleArray(2).Name = "Don't lable me"

How would I resort my the MyPeopleArray to have the people in Age order,
name order or sex order?

Thanks!

Jim



Thanks for the reply, but this solution does not emulate the Array.Sort
function. ICompare only compares two objects and tells you which comes
first. It does not sort the array and does not compare more than 2 objects.

I can code a solution, I was just making sure that I wasn't re-inventing the
wheel.

Thanks again.

Jim

Jul 19 '05 #3
Jim
Thanks for the reply, but this solution does not emulate the Array.Sort
function. ICompare only compares two objects and tells you which comes
first. It does not sort the array and does not compare more than 2 objects.
There is no need to 'emulate the Array.Sort' function, the Array.Sort
function does it for you! Please read the link I gave you for specifics.
http://msdn.microsoft.com/library/de...SortTopic3.asp

As I said you call the Array.Sort function that accepts a Comparer object.
You would pass it a PeopleComparer object, which I gave you, with the
correct property identified:

To sort the array in Age order:
Array.Sort(MyPeopleArray, New PeopleComparer("Age"))

To sort the array in Name order:
Array.Sort(MyPeopleArray, New PeopleComparer("Name"))

To sort the array in Sex order:
Array.Sort(MyPeopleArray, New PeopleComparer("Sex"))

The sort function then calls this Comparer object for each comparison it
needs to do, passing it one pair of objects. As the sort algorithm is
working it will repeatedly call the comparer object. Once all the objects
are in order, the sort function returns & presto your array is sorted.

Hope this helps
Jay
"Jim Hubbard" <Re*****@Group.net> wrote in message
news:yl***************@fe03.atl2.webusenet.com...
"Jay B. Harlow [MVP - Outlook]" <Ja********@email.msn.com> wrote in message news:ur**************@TK2MSFTNGP10.phx.gbl...
Jim,
Define a PeopleComparer class that implements the IComparer interface. The PeopleComparer object would know which property you want to sort on and act
accordingly.

When you call Array.Sort, you would use the overloaded version that

accepts
an IComparer.

For an example see:

http://msdn.microsoft.com/library/de...SortTopic3.asp

I would define the PeopleComparer to accept the property name as a

parameter
to the constructor then have a select case in the compare.

Something like:

Public Class PeopleComparer
Implements IComparer

Private Readonly m_field As String

Public Sub New()
MyClass.New("Name")
End Sub

Public Sub New(ByVal field As String)
m_field = field
End Sub

Public Function Compare(ByVal x As Object, ByVal y As Object) As
Integer _
Implements IComparer.Compare
Dim xo As People = DirectCast(x, People)
Dim yo As People = DirectCast(y, People)
Select Case m_field
Case "Sex"
Return xo.Sex.CompareTo(yo.Sex)
Case "Age"
Return xo.Age.CompareTo(yo.Age)
Case "Name"
Return xo.Name.CompareTo(yo.Name)
End Select
End Function

End Class
Array.Sort(MyPeopleArray, New PeopleComparer("Age"))

Hope this helps
Jay

"its me" <at**@house.com> wrote in message
news:4s*****************@fe02.atl2.webusenet.com.. .
Let's say I have a class of people...

Public Class People
Public Sex as String
Public Age as int
Public Name as string
end class

And I declare an array of this class...

Dim MyPeopleArray(3) as People

Then I fill my arry with 3 people...

MyPeopleArray(0).Sex = "Female"
MyPeopleArray(0).Age = 32
MyPeopleArray(0).Name = "Marsha Marsha Marsha"

MyPeopleArray(1).Sex = "Male"
MyPeopleArray(1).Age = 31
MyPeopleArray(1).Name = "John"

MyPeopleArray(2).Sex = "Can't decide"
MyPeopleArray(2).Age = "23"
MyPeopleArray(2).Name = "Don't lable me"

How would I resort my the MyPeopleArray to have the people in Age order, name order or sex order?

Thanks!

Jim



Thanks for the reply, but this solution does not emulate the Array.Sort
function. ICompare only compares two objects and tells you which comes
first. It does not sort the array and does not compare more than 2

objects.
I can code a solution, I was just making sure that I wasn't re-inventing the wheel.

Thanks again.

Jim

Jul 19 '05 #4
Jay,

After some much needed sleep, I got to use your example.....and man did
it hit the spot.

Thanks again for your help!

Jim

Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Radhika Sambamurti | last post by:
Hi, I'm a relative newbie.... I've written a program to do a bubble sort. take in numbers and sort them. My question is: at the very end of the sort() function, when I have to output the result...
4
by: Todd | last post by:
I'm new to c++ and was wondering how to sort a 2 dimensional array. I'm using a select sort for 1 dimensional arrays but it is not working for a 2 dimensional array. The 2 dimensional array are...
7
by: ritchie | last post by:
Hi all, I am new to this group and I have question that you may be able to help me with. I am trying to learn C but am currently stuck on this. First of all, I have a function for each sort...
6
by: its me | last post by:
Let's say I have a class of people... Public Class People Public Sex as String Public Age as int Public Name as string end class And I declare an array of this class...
21
by: yeti349 | last post by:
Hi, I'm using the following code to retrieve data from an xml file and populate a javascript array. The data is then displayed in html table form. I would like to then be able to sort by each...
5
by: Jan Smith | last post by:
I've searched the overloads for the Array.Sort method, and I haven't found a clear answer to my question. Maybe it's not in Array.Sort. Here's the question: I initialize an array X with the...
13
by: ANSHUL | last post by:
PLEASE PROVIDE ME D SOLUTION CODE FOR DIS PROBLEM. SELECTION SORT IS BASED ON D FOLLOWING IDEA: SELECTING D LARGEST ARRAY ELEMENT AND SWAPPING IT WITH THE LAST ARRAY ELEMENT LEAVES AN UNSORTED...
24
by: Michael | last post by:
Hi, I am trying to pass a function an array of strings, but I am having trouble getting the indexing to index the strings rather than the individual characters of one of the strings. I have...
4
by: VooDoo | last post by:
Hi, I am getting confused with sorting arrays... $arraytest =array(5) { =string(2) "39" =string(2) "44" => string(2) "77" =string(3) "150" =string(3) "464" } why do i get NULL value if i try to...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.