dataset help

[Shahid Juma]

Hi,

I am having a problem extracting data. I am using Microsoft Application
Block and have a query which I want to execute (select query). However,
I just want the data and store it into a variable. The examples I have
seen all have datasets and databinding but not sure what exactly to do
get it.

Any help would be greatly appreciated.

Shahid

 

[Guest]

Hi Shahid,

Following code retrieve data from a dataset:

object data = dataset.Tables[table_index].Rows[row_index][col_index];

Or

object data = dataset.Tables[table_name].Rows[row_index][field_name];

HTH

Elton Wang

 

[Shahid Juma]

Thank you.

I was able to get it working.