[RESOLVED] Stuck on a query to a text box.

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

---