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.ConnectionString")

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")

"Big E" <(E-Mail Removed)> wrote in message
news:%23b2QR$(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> "Big E" <(E-Mail Removed)> wrote in message
> news:%23b2QR$(E-Mail Removed)...
> > 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
>
>

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

--
John Saunders
johnwsaundersiii at hotmail

"Big E" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > "Big E" <(E-Mail Removed)> wrote in message
> > news:%23b2QR$(E-Mail Removed)...
> > > 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
> >
> >
>
>