Retrieving records from datatable

preethadotnet

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 :

Expand|Select|Wrap|Line Numbers

 DataTable dtTransID = new DataTable(); 

DBConnect(); 

string sp=" exec "+storedProcedure+"  ";

dtTransID =mDB.RunSp(sp);

if(dtTransID.Rows.Count >0)

{

for(i=0;i<dtTransID.Rows.Count;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

kenobewan

Perhaps no rows are being returned from your stored procedure? You may also need a datareader.

preethadotnet

Quote:

Originally Posted by kenobewan

Perhaps no rows are being returned from your stored procedure? You may also need a datareader.

No kenobewan...That count shows as 8.but its not reading the values.....

Plater

dtTransID.Rows[0] is a DataRow object, you are trying to use it as a string
if you only want the first column of the first row, try maybe:
dtTransID.Rows[0][0].ToString()

Retrieving records from datatable

re: Retrieving records from datatable

re: Retrieving records from datatable

re: Retrieving records from datatable

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about