Results 1 to 2 of 2

Thread: DataGrid using ADO

  1. Oct 27th, 2000, 02:03 PM #1
    ACN1234
    ACN1234 is offline

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Posts
    2

    Question

    I am trying to using an input box that allows the users to search a particular string in a field and then have only those records display in the datagrid. However, what is happening is that all the records from the table are being displayed. I am using the datasource property to tell the grid what table I am using. Any help would greatly be appreciated!
    Reply With Quote Reply With Quote
  2. Oct 27th, 2000, 02:43 PM #2
    barrk
    barrk is offline
    Hyperactive Member barrk's Avatar
    Join Date
    Sep 2000
    Location
    My own little world
    Posts
    274
    are you passing the value of the input box to the adodc and doing a refresh?

    myvalue = inputbox.text

    mysql = "select * from mytable where myfield = '" & myvalue & "'"

    adodc.recordsource = mysql
    adodc.refresh
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width