Urgent help requested. How do I add a DB table cell's text item from a dataset to a TextBox?
ASP.Net WebForms, C#, Sql Server
...
da.SelectCommand = new OleDbCommand("select * from DB_TABLE_NAME where COLUMN_NAME = '" + TEXTBOX_1.Text + "'", myConnection);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
myConnection.Open();
DataSet ds = new DataSet("DB_TABLE_NAME");
da.Fill(ds);
--code required--
myConnection.Close();
How can I now extract from the DataSet, a cell's text Item, and add it to a different textBox, say TEXTBOX_2.Text on my webform?