Need help with database stuff! **SOLVED**

Hey its me ..... again.......

Ok here we go,
all I want is one String value returned from my Database. (SQLSERVER). Here is my code with what I do up till now:

Code:

---

                        string sConn = "server=local;Trusted_Connection=yes;database=InternalIdTracking";
                        string command = "UPDATE Tracking SET status ='" +type_number +"' WHERE( mappedId LIKE '"+localid + "')" ;
                       
                        SqlConnection conn = new SqlConnection(sConn);
                        conn.Open();
                        SqlCommand execute = new SqlCommand(command,conn);
                        execute.ExecuteNonQuery();
                       
                        command = "SELECT internalId FROM Tracking Where (mappedId LIKE '"+localid+"')";
                        SqlCommand selectId        = new SqlCommand(command,conn);
                        string selectedid = selectId.ExecuteNonQuery().ToString(); //this is not working
                       
                        conn.Close();



                        return "selectedid";

---

Thanx,
Stephan

PLEASE, need some help here!

Ok lets not get to difficult on this one. How can I read Data from my Database using a SQL Statement and convert it to a string?

With my posted code above I only get a -1 !

Please gimme a hand on this one :(

Thanx Stephan

UPDATE Ok i found out that dataset stuff, but how can I get a value out of that dataset thingy?

heres my code:

Code:

---

command = "SELECT internalId FROM Tracking Where (mappedId LIKE '"+localid+"')";
SqlCommand selectId        = new SqlCommand(command,conn);
string selectedid = "";

System.Data.DataSet rs = new DataSet("internalId");

SqlDataAdapter daad = new SqlDataAdapter(command,conn);
daad.TableMappings.Add("Table","internalId");
daad.Fill(rs);

selectedid = rs.Tables["internalId"].Columns["internalId"].;
selectedid = rs.Tables["internalId"].Rows[0].ToString();
                       
conn.Close();

---

Thanx, Stephan

Ok I solved this using a DataReader!

Stephan