filling an array from a dataset

[amber]

Hello,

How can I declare an array, and set it to equal all the items in a column of
a dataset?

TIA,

Amber

[Cor Ligthert [MVP]]

Amber,

A dataset has no column, what do you mean?

Cor

[CT]

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

[Cath]

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

[CT]

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