Populating a text field

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.
TimSweet220Asked:
Who is Participating?
 
sagacitysolutionsConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.