C# : how to get a value from a dataset?

[RD]

clsConnect ObjConnect = new clsConnect();

string ConnectionString=ObjConnect.Connstring;

SqlConnection myConn=new SqlConnection(ConnectionString);

SqlCommand myCMD = new SqlCommand("SELECT * from Customer Where CustomerId
= 1",myConn);
SqlDataAdapter myDA = new SqlDataAdapter();

myDA.SelectCommand = myCMD;

myConn.Open();

DataSet myDS = new DataSet();

myDA.Fill(myDS);

----------------------------------------------------------------------------
-

Now I want to get the values of specific fields.
(Lastname,firstname,------------) How can I do that?

Thanks

RD

[Alvin Bruney]

for(int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

ds.Tables[0].Rows[i][0].ToString();// = first name
ds.Tables[0].Rows[i][1].ToString();// = last name
ds.Tables[0].Rows[i][2].ToString();// = ---------
}
for simple values you really should consider using a data reader instead of
a dataset. its faster because there is less overhead

--
Regards,
Alvin Bruney
Got tidbits? Get it here...
http://tinyurl.com/3he3b
"RD" <di******@alltel.net> wrote in message
news:%8*************@fe01.usenetserver.com...

clsConnect ObjConnect = new clsConnect();

string ConnectionString=ObjConnect.Connstring;

SqlConnection myConn=new SqlConnection(ConnectionString);

SqlCommand myCMD = new SqlCommand("SELECT * from Customer Where CustomerId = 1",myConn);
SqlDataAdapter myDA = new SqlDataAdapter();

myDA.SelectCommand = myCMD;

myConn.Open();

DataSet myDS = new DataSet();

myDA.Fill(myDS);

-------------------------------------------------------------------------- -- -

Now I want to get the values of specific fields.
(Lastname,firstname,------------) How can I do that?

Thanks

RD