Dataset into array

[Poppy]

Can someone point me to an example of populating an array from either a
dataset or a datareader ?

This .net stuff is killing me.

[Gerry O'Brien [MVP]]

Try this, assuming your data can be a string;

Dim arData() As String
Dim ds As New DataSet
' Fill your dataset in your own way here

ReDim arData(ds.Tables(0).Rows.Count)

For intCounter As Integer = 0 To ds.Tables(0).Rows.Count - 1
arData(intCounter) = ds.Tables(0).Rows(intCounter).Item(0).ToString

Next

--
Gerry O'Brien
Visual Developer .NET MVP
Visual Basic

"Poppy" <pa**********@NOSPAMthemedialounge.com> wrote in message
news:e6**************@tk2msftngp13.phx.gbl...

Can someone point me to an example of populating an array from either a
dataset or a datareader ?

This .net stuff is killing me.

[Ashish M Bhonkiya]

Hi,

Following code will help you to populate the data from the datareader in to
an arraylist.

ArrayList rowList = new ArrayList();
SqlDataReader reader = storedProcCommand.ExecuteReader();
while (reader.Read())
{
object[] values = new object[reader.FieldCount];
reader.GetValues(values);
rowList.Add(values);
}

10Cents
Regards
Ashish M Bhonkiya

"Poppy" <pa**********@NOSPAMthemedialounge.com> wrote in message
news:e6**************@tk2msftngp13.phx.gbl...

Can someone point me to an example of populating an array from either a
dataset or a datareader ?

This .net stuff is killing me.

[Poppy]

Thanks All

Much Appreciated.
"Ashish M Bhonkiya" <bh******@hotmail.com.nospam> wrote in message
news:u#**************@TK2MSFTNGP12.phx.gbl...

Hi,

Following code will help you to populate the data from the datareader in to an arraylist.

ArrayList rowList = new ArrayList();
SqlDataReader reader = storedProcCommand.ExecuteReader();
while (reader.Read())
{
object[] values = new object[reader.FieldCount];
reader.GetValues(values);
rowList.Add(values);
}

10Cents
Regards
Ashish M Bhonkiya

"Poppy" <pa**********@NOSPAMthemedialounge.com> wrote in message
news:e6**************@tk2msftngp13.phx.gbl...

Can someone point me to an example of populating an array from either a
dataset or a datareader ?

This .net stuff is killing me.