Need help with database stuff! **SOLVED**

[Sgt-Peppa]

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:

			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