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