How to convert datatable into an arraylist

[Steve]

I have a very simple datatable of 1 column which I retrieve from a
database, call it 'data'.

Dim data As Data.DataTable
data = myobject.mymeth od(parameter)

I want to now turn this 'data' into an arraylist and I don't know how.
Can anyone help?

And finally I want to convert the arraylist to a 'string array' which I
think can be done by:

Dim ListArray As String() = List.ToArray(Ge tType(String))

Please help in vb.net code. I am using asp.net 2.0 if that makes any
difference.

[Karl Seguin]

I doubt you'll find a way to implicitely conver it. You'll need to loop
through and add

dim Listas new ArrayList(data. Rows.Count)
for each row as DataRow in data.Rows
List.Add(row(0) )
next

ur convert to string is fine, you'll need to
ctype(List.ToAr ray(GetType(Str ing), string()) (cast to string array) more
than likely

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/

"Steve" <ba****@iranman ia.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

I have a very simple datatable of 1 column which I retrieve from a
database, call it 'data'.

Dim data As Data.DataTable
data = myobject.mymeth od(parameter)

I want to now turn this 'data' into an arraylist and I don't know how.
Can anyone help?

And finally I want to convert the arraylist to a 'string array' which I
think can be done by:

Dim ListArray As String() = List.ToArray(Ge tType(String))

Please help in vb.net code. I am using asp.net 2.0 if that makes any
difference.

[Steve]

Thank you Karl. I think this should do it. As you say, it's a pitty
there isn't a simple built in method to turn a datatable into an array.