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