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