Q: data in dataset

[JIM.H.]

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

"JIM.H." <JI**@discussions.microsoft.com> wrote in message
news:A9**********************************@microsof t.com...

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.