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

 

[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]

Thanks All

Much Appreciated.

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

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

This .net stuff is killing me.