Results 1 to 2 of 2

Thread: SQL Find

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2002
    Location
    Pilipinas
    Posts
    441

    SQL Find

    I have add a DataGrid into the Form and I already connect its DataSource and DataMember.
    I add a Button and put this code.
    Dim aa as String
    aa=InputBox("Search","Search for Employee No.")

    DataAdapter1.SelectCommand.CommandText = & _
    "SELECT * FROM Employee WHERE " & _
    "ID = ' " & aa & "' " & _
    DataAdapter1.Fill(DataSet11)

    But there's no change.
    What's wrong with this code?

  2. #2
    Lively Member
    Join Date
    Nov 2002
    Location
    Malaysia
    Posts
    124
    You have only need to connect Properties -> DataSource = DataSet11, Don't connect the DataMember

    And Don't Connect Properties - > DataBinding - > DataSource

Posting Permissions

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



Click Here to Expand Forum to Full Width