populate text box with sql

[davedizzle15]

does anyone know how to populate a text box with an sql query using .net 1.1?

 

[adugenet]

this might give you a clue how to populate a text box

'create a new dataset to hold our data
Dim myDataSet As New DataSet


'fill the dataset with the result of our query from the specified command
myAdapter1.Fill(myDataSet, "phldetail")

'Bind the DataSet to the GridView
gvphldetail.DataSource = myDataSet
gvphldetail.DataBind()
lblsp.Text = myDataSet.Tables("phldetail").Rows(0).Item("columnname").ToString()

 

[davedizzle15]

is this also possible to do with a formview in microsoft web developer?

 

[jbenson001]

yes but since the textbox will be within the formview, you will have to use the findcontrol() method to find the control first.