filling an array from a dataset

[Guest]

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.

 

[Guest]

can you explain how to do that?

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

 

[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