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.

Code:
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();