Q: data in dataset

[Guest]

I populate DS and trying to reach each field value,
sqlConn.Open();
DA.Fill(DS);
sqlConn.Close();

// populate textbox
string myField = DS.Tables[0].Rows["myField"].ToString();
tbMyField.text= myField;


DS.Tables[0].Rows["myField"].ToString() does not work. How would you do this?
Thanks,
Jim.

 

[Eliyahu Goldin]

If you want to read from the first row:

DS.Tables[0].Rows[0]["myField"].ToString();

Did you consider typed datasets?

Eliyahu