Getting values from a data source?

[columbo2]

Hi All,

If I have a datasource and run the SELECT method of it.
i.e

datasource.select();

How do I then get at the values without using a datagrid or repeater or whatever.

i.e. I have textboxes and I want to write the results of the select statement to these text boxes (only one record will display.

ta
c

 

[JurkMonkey]

DataSet ds = new DataSet();

//Run your select to fill the Dataset here
...

foreach (DataRow row in ds.Tables[0].Rows)
{
Console.WriteLine(row["FirstName"].ToString());
}

http://www.ubuntu.com/