«

column in the current row? For example, I have a datagrid
filled up with a database and the user clicks on the edit
button. I want to go to another page and edit this row.
How do I get the data from this row? I dont want to get
the data from the grid row, but the current row of my
dataset. Please help! Thanks.
Dave

Hi Dave,
You can get the data from a datarow,
If dr is the datarow,
dr["columname"] will give you the value of the column in the
datarow or if you know
the index you can use dr[index])(index can be starting from 0,1,2,.....).
If you want to iterate through each row in the datarowcollection
in the datatable in the dataset,
If ds is the dataset,

foreach(DataRow dr in ds.Tables[0].Rows)

{

access each column value here like the way I described above.

}

Hope this helps.

Marshal Antony

..NET Developer

http://www.dotnetmarshal.com






"Dave" <> wrote in message
news:f2d701c3f12f$167e2ab0$...
> column in the current row? For example, I have a datagrid
> filled up with a database and the user clicks on the edit
> button. I want to go to another page and edit this row.
> How do I get the data from this row? I dont want to get
> the data from the grid row, but the current row of my
> dataset. Please help! Thanks.
> Dave

Hi Marshal. Thanks for the reply.. I did this and it works!

DataTable dt = ds.Tables[0];
DataRow[] dr = dt.Select();
textFIRST.Text = dr[0]["FNAME"].ToString();
textLAST.Text = dr[0]["LNAME"].ToString();
textPHONE.Text = dr[0]["PHONE_NUMB"].ToString();

Thanks.
Dave



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!