Here's one way:
' Populate dataset
SqlDataAdapter1.Fill(dataset1, "Categories")
' Create and dimension row array
Dim rows(dataset1.Tables("Categories").Rows.Count) As DataRow
' Loop through all rows in Categories table
For i As Integer = 0 To dataset1.Tables("Categories").Rows.Count - 1
rows(i) = dataset1.Tables("Categories").Rows(i)
Next
--
Carsten Thomsen
Communities -
http://community.integratedsolutions.dk
"Cath" <Ca**@discussions.microsoft.com> wrote in message
news:6C**********************************@microsof t.com...
can you explain how to do that?
"CT" wrote:
I assume you want to copy the rows from a table in the DataSet, right? If
so, you need to manually loop through the rows and copy across to the
array.
--
Carsten Thomsen
Enterprise Development with VS .NET, UML, AND MSF
http://www.apress.com/book/bookDisplay.html?bID=105
Communities - http://community.integratedsolutions.dk
"amber" <am***@discussions.microsoft.com> wrote in message
news:39**********************************@microsof t.com... > Hello,
>
> How can I declare an array, and set it to equal all the items in a
> column
> of
> a dataset?
>
> TIA,
>
> Amber