How to reference the value of a specific field in a DataSet

[Guest]

I've just filled a dataset with 1 row from a table in my database
I want to get the value of one of the fields

I'm using

string atLastMyValue
DataSet ds
DataTable dt
DataRow dr; in myTable.Rows
DataColumn dc
dt = ds.Tables[0]
dr = dt.Rows[0]
dc = dt.Columns["myFieldName"]
atLastMyValue = dr[dc].ToString()

Is there a simpler way to reference the field?

 

[Marina]

Yes: myDS.Tables["MyDataTable"].Rows[0]["MyColName"] will gives you the
value of MyColName in the first row of a datatable named MyDataTable.

 

[Guest]

Yes

atLastMyValue = ds.Tables[0].Rows[0]["myFieldName"].ToString()

----- Grant Ord wrote: ----

I've just filled a dataset with 1 row from a table in my database
I want to get the value of one of the fields

I'm using

string atLastMyValue
DataSet ds
DataTable dt
DataRow dr; in myTable.Rows
DataColumn dc
dt = ds.Tables[0]
dr = dt.Rows[0]
dc = dt.Columns["myFieldName"]
atLastMyValue = dr[dc].ToString()

Is there a simpler way to reference the field?