To read data from dataset in VB

**Chandrakant81** · 03-02-2009

Hi,
I have this code but I don't know where I have made mistake?
I have 2 tables X & Y in dataset.
Now i would like to loop through records of tableA (in the dataset) and read the
values.

Code:

for (long i = 0; i <= oDataSetMessages.Tables["tableA"].Rows.Count; i++)
{
long lngPrimaryKeyId =
Convert.ToInt64(oDataSetMessages.Tables["tableA"].Columns["PrimaryKeyId"]);
Response.Write (lngPrimaryKeyId);
}

**Alphonsus** · 03-02-2009

You can also try this:

Code:

nYearValue = (System.Int16) myTable.Rows[nLoop]["nYear"];

**Ettan** · 03-02-2009

You can also try this:

Code:

use this function to get all the data in ur data table

public void PrintTable(DataTable myTable)
{
foreach(DataRow myRow in myTable.Rows)
{
foreach(DataColumn myColumn in myTable.Columns){
Response.Write(myRow[myColumn]);
}
}
}