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

[Sgt-Peppa]

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

[Sgt-Peppa]

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

heres my 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

[Sgt-Peppa]

Ok I solved this using a DataReader!

Stephan