Get specific row value

<i><b>Originally posted by : Virtual (virtualnet@im.eth.net)</b></i><br />Hi, <br />I am using the DataSet ... <br /><br />DataSet ds = new DataSet(); <br />cmd_DB.FillDataSet(ds, "myMDB_DBS"); <br /><br />I need to get the value of one field & store it in a session variable. <br />How do I do that ??? <br /><br />eg. in a tabel structure such as.... <br />id, username, password. <br />I am using a <br /><br />select * from myMDB_DBS where username="nicole" <br /><br />query to filldataset. <br /><br />How do I get the value <br />of the password field to store into a session variable ??? <br /><br />Please help <br />

<i><b>Originally posted by : Jenica (jenica@mvsc.com)</b></i><br />string pwd = ds.Tables[0].Rows[0]["PasswordField"].ToString();<br /><br />this.Context.Session.Add("password",pwd);<br /><br /><br />------------<br />Virtual at 1/22/2001 3:30:54 AM<br /><br />Hi, <br />I am using the DataSet ... <br /><br />DataSet ds = new DataSet(); <br />cmd_DB.FillDataSet(ds, "myMDB_DBS"); <br /><br />I need to get the value of one field & store it in a session variable. <br />How do I do that ??? <br /><br />eg. in a tabel structure such as.... <br />id, username, password. <br />I am using a <br /><br />select * from myMDB_DBS where username="nicole" <br /><br />query to filldataset. <br /><br />How do I get the value <br />of the password field to store into a session variable ??? <br /><br />Please help <br />