Results 1 to 2 of 2

Thread: Searching for data in a table...HOW?

  1. Aug 3rd, 2004, 05:46 PM #1
    brendalisalowe
    brendalisalowe is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2004
    Location
    Utah, USA
    Posts
    353

    Searching for data in a table...HOW?

    There is going to be data put into a textbox and I need to be able to search through a SQL Server table and have it find it then return that record. Does anyone know how to do that? I have NEVER done it before. Any help would be GREAT! Thanks!

    Brenda
    Reply With Quote Reply With Quote
  2. Aug 4th, 2004, 01:35 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    The SQL Query you use to populate your dataset, would be something like

    VB Code:
    1. "SELECT * FROM tablename WHERE fieldname LIKE '%" & TextBox1.Text & "%';"
    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