Solved

Populating a text field

Posted on 2006-07-17
1
256 Views
Last Modified: 2010-04-23
Here where I fill my dataset  which consists of two field     Img and pathway

Private Sub Pathway_Fill()
        Dim ds As DataSet

        ds = New DataSet("tblPathway")
        SqlDataAdapter_getPathway.SelectCommand.Parameters("@ABR_ID").Value = Me.txtABR_ID.Text
        SqlDataAdapter_getPathway.Fill(ds, "tblPathway")


    End Sub

I call it when the form loads


The field I need to populate is txbPathway and it needs to populate with the "pathway" field from the ds.

I'm missing the code that will do that last portion.

Thanks.
0
Comment
Question by:TimSweet220
1 Comment
 
LVL 8

Accepted Solution

by:
sagacitysolutions earned 500 total points
ID: 17126237
Try This

Private Sub Pathway_Fill()
        Dim ds As DataSet

        ds = New DataSet("tblPathway")
        SqlDataAdapter_getPathway.SelectCommand.Parameters("@ABR_ID").Value = Me.txtABR_ID.Text
        SqlDataAdapter_getPathway.Fill(ds, "tblPathway")

        If ds.Tables.Count > 0 Then
           If ds.Tables.Rows.Count > 0 Then
               txbPathway.Text = ds.Tables("tblPathway").Rows(0).Cells("Pathway")
           End If
        End If

    End Sub
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question