How to retrieve records from a Datatable

Hi,

Can anyone tell me how to retrieve record values from a datatable?.My requirement is like:

Within a for loop I am executing different stored procedures and storing records in a datatable so that i cannot specify paticular column names.i want to write the first row values of each result into a log file.(application is windows service)
Code is :

DataTable dtTransID = new DataTable();
DBConnect();
string sp=" exec "+storedProcedure+" ";
dtTransID =mDB.RunSp(sp);
if(dtTransID.Rows.Count >0)
{
for(i=0;i{
if (storedProcedure!=null)
{
message = message + Datetime.Now+ "\n + dtTransID.Rows[0] +, - ";
message = message + dtTransID.Rows[0] + ",";
Globals.log.logMessage(message);

}

dtTransID.Rows[0] -This line is returning 'system.data.rows' not any records.
Please help me..
Thanks in advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Thirupathi v18y ago
Hi First you should fill the Values from database to datatable. like.

dim Ds as new Dataset

dim Cmd as new sqlcommand("Exec " ,con)

dim ada as new sqldataadapter(cmd)

ada.Fill(Dataset,"DataTableName")

Now you have to decalre the Datatable Like

Dim Dt as data.DataTable=Ds.DatatableName

Dim Dr() as data.DataRow=Dt.Select();

For i = 0 to Dr.Length-1

lbl.Text=Dr(i).Item("FieldName")

Next

By using the above code, we can retrive the all values from DataTable.