Loop through a dataset to get values, vb .net

[edpdc]

VB .NET
I would like to know how to loop through each row in a data set and
get a value from a colum in the data set. My data set has multiple
columns. I know I have to use the datarow class but I'm not sure how
to do this. I would like to use a for each loop.
Any help would be appreciated.

 

[Shiva]

Hi,
Actually, datasets do not contain datarows or columns. Only datatables have
them.

Here is a code snippet that does the looping:

Dim dr As DataRow
Dim ds As Dataset
Dim dt As DataTable
<code to fill the dataset>
dt = ds.Tables(0)
For Each dr In dt.Rows
Console.WriteLine (dr("ColName"))
Next
ds.Dispose()

Hope this helps.

VB .NET
I would like to know how to loop through each row in a data set and
get a value from a colum in the data set. My data set has multiple
columns. I know I have to use the datarow class but I'm not sure how
to do this. I would like to use a for each loop.
Any help would be appreciated.

 

[Nick Malik]

If you are going to make a point of asking a question in the csharp
newsgroup, you should expect to get your answer in C#.

DataTable tbl = myDataSet.Tables[0];
for (int i = 0; i < tbl.Rows.Count; i++)
{
DataRow myRow = tbl.Rows;
string MyValue = myRow["datafieldname"];
}

This can be written more efficiently... I drew out the data types for
clarity.
--- N

 

[Ed P]

Thanks for the reply it helped.

 

[The Last Gunslinger]

VB .NET
I would like to know how to loop through each row in a data set and
get a value from a colum in the data set. My data set has multiple
columns. I know I have to use the datarow class but I'm not sure how
to do this. I would like to use a for each loop.
Any help would be appreciated.

Since this is a c# ng, code is in c#

DataSet ds = new DataSet();
foreach(DataRow dr in ds.Tables[0].Rows)
{
Console.WriteLine(dr["ColName"].ToString());
}

HTH
JB