Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Angry Unanswered: SqlDataAdapter??


    How can i add into this statement to select data from another table.

    Let's say i have another table called FollowUp_Response with column Response..

    I want to add it in this code for one statement only. i'm using for this project.

    objDataAdapter = New SqlDataAdapter( _
    "SELECT FollowUp.followup_num " & _
    "FROM FollowUp", myConnection)

    objDataAdapter.Fill(objDataSet, "FollowUp")

    objDataView = New DataView(objDataSet.Tables("FollowUp"))


    My aim is to pull the data from the database and to display them in an interface.

    Thanks in advance

  2. #2
    Join Date
    Mar 2003
    What is the relationship between the 2 tables?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts