Urgent help requested. How do I add a DB table cell's text item from a dataset to a TextBox?

Feb 12 2004 11:10 AM
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?

Answers (1)