Binding textboxes

[Big E]

I create a Connection, SQL DataAdapter, DataTable, DataSet and Fill the
Table. Now I want to bind the data in the Table to textboxes on the ASP.Net
page. I thought I could do something as simple as Textbox1.Text =
dtReg.Columns.Row(dataintable). I would rather do it in the .vb file than in
the aspx page.

I can't figure out how to do it.

Thanks.

Dim Portal As String

Dim dsReg As DataSet

Dim cnPortal As SqlConnection

Dim daReg As SqlDataAdapter

Dim dtReg As DataTable = New DataTable

Portal = ConfigurationSettings.AppSettings("Portal.Connecti onString")

dsReg = New DataSet

cnPortal = New SqlConnection(Portal)

daReg = New SqlDataAdapter("SELECT * FROM tblProspect WHERE Fname= '" &
varFirstName & "' and Lname ='" & varLastName & "'and HomePhone ='" &
varPhone & "'", cnPortal)

daReg.Fill(dsReg, "tblProspect")

dtReg = dsReg.Tables("tblProspect")

[John Saunders]

"Big E" <no****@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I create a Connection, SQL DataAdapter, DataTable, DataSet and Fill the
Table. Now I want to bind the data in the Table to textboxes on the ASP.Net page. I thought I could do something as simple as Textbox1.Text =
dtReg.Columns.Row(dataintable). I would rather do it in the .vb file than in the aspx page.

Did that even compile?

Try dtReg.Rows(intRowNum)("columnName") instead.
--
John Saunders
johnwsaundersiii at hotmail

[Big E]

No it didn't compile. I just made that up as a example of the various things
I've tried.

What is the part after Rows..... --> (intRowNum).?
I've used that when I have a combobox and add contents through looping. How
would I use it if there will only be one record with a textbox.

Thanks.
"John Saunders" <jo**************@notcoldmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

"Big E" <no****@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I create a Connection, SQL DataAdapter, DataTable, DataSet and Fill the
Table. Now I want to bind the data in the Table to textboxes on the ASP.Net

page. I thought I could do something as simple as Textbox1.Text =
dtReg.Columns.Row(dataintable). I would rather do it in the .vb file

than in

the aspx page.

Did that even compile?

Try dtReg.Rows(intRowNum)("columnName") instead.
--
John Saunders
johnwsaundersiii at hotmail

[John Saunders]

If there's only one row, then use (0).

--
John Saunders
johnwsaundersiii at hotmail

"Big E" <no****@nospam.com> wrote in message
news:OR**************@TK2MSFTNGP09.phx.gbl...

No it didn't compile. I just made that up as a example of the various things I've tried.

What is the part after Rows..... --> (intRowNum).?
I've used that when I have a combobox and add contents through looping. How would I use it if there will only be one record with a textbox.

Thanks.
"John Saunders" <jo**************@notcoldmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

"Big E" <no****@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I create a Connection, SQL DataAdapter, DataTable, DataSet and Fill the Table. Now I want to bind the data in the Table to textboxes on the

ASP.Net

page. I thought I could do something as simple as Textbox1.Text =
dtReg.Columns.Row(dataintable). I would rather do it in the .vb file

than

in

the aspx page.

Did that even compile?

Try dtReg.Rows(intRowNum)("columnName") instead.
--
John Saunders
johnwsaundersiii at hotmail