Loading

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

spacegazer11

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

spacegazer1122y ago
Its ok, I found it. the code is as follows: First I changed the select to 'select COLUMN_NAME from...' instead of an asterix. Then. after the da.Fill(ds), I added the following: lblLabelName.Text = myDataSet.GetXml(); It places, in the label, the record retrieved with the select. It's all good from there!
+1