Reading single field values from a dataset

[Bjorn Sagbakken]

What is the best way to read single field values from a dataset? The dataset
is populated with a customer record, showing well in a gridview. But I also
want to read the single field values, like adress, phone, and so on.

Bjorn

 

[Guest]

What is the best way to read single field values from a dataset? The dataset
is populated with a customer record, showing well in a gridview. But I also
want to read the single field values, like adress, phone, and so on.

Bjorn

for example, myDataSet.Tables[0].Rows[0][0]

it gives you a value of the first colum in the first row

 

[Bjorn Sagbakken]

What is the best way to read single field values from a dataset? The
dataset
is populated with a customer record, showing well in a gridview. But I
also
want to read the single field values, like adress, phone, and so on.

Bjorn

for example, myDataSet.Tables[0].Rows[0][0]

it gives you a value of the first colum in the first row

Thanks a lot. That was exactly what I was looking for.

Bjørn

 

[sloan]

Is it a strong or weak typed DataSet?

Let's say you have
EmployeeDS
with one table : Employee
and 3 columns
EmployeeID (int) , LastName (string) , FirstName (string)


Here is some pseudo code:


EmployeeDS ds = new EmployeeDS();

ds.Employee.AddNewEmployeeRow ( 101, "Smith" , "John") ;

.........

EmployeeDS.EmployeeRow row = ds.Employee.Rows[0] as EmployeeDS.EmployeeRow;
// friendly cast
if(null!=row)
{
int empid = row.EmployeeID;
}