Click to See Complete Forum and Search --> : [RESOLVED] Stuck on a query to a text box.


forgottenhart
March 2nd, 2011, 01:11 PM
Hi,

I am stuck trying to read a specific column within a table to a textbox. I know my connection string is correct because I am able to load other data from the database in to various combo boxes. However I am stuck on how to get one piece of data into one textbox.


string current_session = "Select s_name from sessions where s_id ='1'";

myconnection.Open();
SQLiteCommand s_cmd = new SQLiteCommand(current_session, myconnection);

//update logged_TB to show the results from the current_session query


myconnection.Close();