getting a single databse value into text box

Question

I would really appreciate if there is any reference to show in how i could transfer value from database into textbox. This my code for combobox, but instead of combobox i would like in textbox

        OleDbDataAdapter oda = new OleDbDataAdapter("select subject_name from  subjecti where subject_name = '" + comboBoxSubjectName.Text + "'", con);
        DataTable dt = new DataTable();
        oda.Fill(dt);
        comboBoxSubjectCodeUpdate.DataSource = dt;
        comboBoxSubjectCodeUpdate.DisplayMember = "subject_name";

Answer 1

You can try something like this

string myquery = "SELECT MyColumn FROM MyTable";

using (var command = new OleDbCommand(myquery, connection))
{
  MyTextBox.Text = command.ExecuteScalar().ToString();
}

Please note if you will be returning multiple values then I suggest you use ExecuteReader() as ExecuteScalar() only returns a single value.