Sort an Array List

[Doug Bell]

Hi,
I have a function that loads Rows from a field in a DataTable into an
ArrayList.
See below:

It also adds a Row (eg "All Areas").
I wanted this new row to be the first record so I added a preceeding space
(eg " All Areas") and sorted the ArrayList.

I have just found that there are some valid records that have one or more
spaces so my added record is no longer first item in the list.

Is there a way to create a custom sort for the ArrayList so that my added
item is first in the list?

Thanks

Doug

Private Function dacFillCombo(By Val stTblNam As String, ByVal stDspFld As
String, _

ByVal stDsplVal As String) As ArrayList

Dim dr As DataRow, al As New ArrayList

Try

al.Add(stDsplVa l)

For Each dr In dsFiles.Tables( stTblNam).Rows

al.Add(dr(stDsp Fld).ToString)

Next

al.Sort()

Return al

Catch ex As Exception

MsgBox(ex.ToStr ing)

End Try

End Function

[Cor Ligthert [MVP]]

Doug,

What do you want to achieve?

It looks to something that can be done in one or more methods/properties in
either the datatable or either the Combobox.

Cor

[Doug Bell]

Hi Cor,
What I am trying to achieve is to have an array list (independant of the
DataTable)
sorted ascending but with one item that is added to the list (and it does
not come from the datatable) always set to be the first item.

The array list is the data source for one or more combo boxes.

I created a function to fill the populate the list and add the new item and
set it to the combo box because this happens with a number of combo boxes
and with a number of tables.

Doug

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:uu******** ******@TK2MSFTN GP12.phx.gbl...

Doug,

What do you want to achieve?

It looks to something that can be done in one or more methods/properties in either the datatable or either the Combobox.

Cor

[Cor Ligthert [MVP]]

Dough,

I don't see the purpose of the arraylist while you can create as much
dataviews as you want which do the job probably much easier, so why an
arraylist?

Cor

[Doug Bell]

How do I add an extra item to a dataview?

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:uf******** ******@TK2MSFTN GP12.phx.gbl...

Dough,

I don't see the purpose of the arraylist while you can create as much
dataviews as you want which do the job probably much easier, so why an
arraylist?

Cor

[Cor Ligthert [MVP]]

Doug,

How do I add an extra item to a dataview?

If you only want to proof that your arraylist is the solution without
telling why, than don't ask for help.

Probably there are better solutions and therefore it has no reason for
others to spent time for that.

In my opinion should you than just investigate it yourself.

Cor

[Doug Bell]

Cor,
I don't understand your response.

As I explained, I need to add a row item and then sort the data except for
the new item that has to be at the top of the list.

You have not provided me with a solution except to say that a DataView is
better than using an Array List.

If you can explain how I can add an item to a DataView and then do a sort so
that everythin is sorted ascending except for the new item which should be
the top item, then I will appreciate your response.

If you can not provide a solution then that is fine also. (I realise MVPs
can only do so much and it is good that they give up time to help others)

Using an ArrayList allows the new item to be added but I don't know if there
is a way to sort it to get the desired result, just as I don't know if there
is a way to sort a dataview to get that result.

Doug
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:eg******** ******@TK2MSFTN GP10.phx.gbl...

Doug,

How do I add an extra item to a dataview?

If you only want to proof that your arraylist is the solution without
telling why, than don't ask for help.

Probably there are better solutions and therefore it has no reason for
others to spent time for that.

In my opinion should you than just investigate it yourself.

Cor

[Cor Ligthert [MVP]]

Doug.

With the few information you gave me, will adding a column in your datatable
probably be the most easy solution. That column can be than the source for
your sortproperty in the dataview.

I hope this helps,

Cor

[Doug Bell]

Thanks Cor,

That does give me something to work on.

I can't add a column to the DataTable as the new item is not in the
datatable but I can add a column to the ArrayList and maybe sort by column
and then by the column that holds the data (assuming that I can sort the
list by 2 columns).

I can not change the datatable/s as they are common sources for many
different selection combo boxes.

Doug
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:OU******** *****@TK2MSFTNG P14.phx.gbl...

Doug.

With the few information you gave me, will adding a column in your datatable probably be the most easy solution. That column can be than the source for
your sortproperty in the dataview.

I hope this helps,

Cor

[Cor Ligthert [MVP]]

Doug,

I can't add a column to the DataTable as the new item is not in the
datatable

Why not, if you cannot add it to the datatable, than it is probably more
work to add it to an arraylist?

Cor