Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder Bengal313's Avatar
    Join Date
    Jun 2002
    Location
    Metro Detroit
    Posts
    298
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Database connection and searching

    I am a new web designer wanna be. I need to learn how to do the following. Conncect to a MS access database (db1). And search a 2 fields, "Street_number" and Street_name". I want to have a ASP page where I will have two text boxes to enter either number or name. When click on Search, the page should search through the database (db1) and return with a table that contains all the records that have those keywords. It also should desplay other information such as owner name, house value, tax, etc. Please is there anyone that can show me an example where I can modify it to do this or can some be kind enough to write it. Your help will be greatly appriciated. Shakim@hotmail.com
    "Knowledge Speaks But Wisdom Listens"

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Location
    Cincinnati, OH
    Posts
    545
    Thanks
    0
    Thanked 0 Times in 0 Posts
    For Access connection:
    http://www.planet-source-code.com/vb...=6442&lngWId=4

    As far as the other asp info do a search on google for asp examples, there will be a ton of them.

  • #3
    New Coder
    Join Date
    Jun 2002
    Location
    Pilipinas
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hi, here's something you may find helpful.

    Letting users search for information

  • #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    41 8' 52" N -95 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Once you get the db connection down, I have a pretty good search function you might want to modify - email me if you want to try it.

    For some good info (besides checking out Dave Clark's links in this thread), you might also want to check out these sites:

    http://www.liquidrage.com
    http://www.4guysfromrolla.com
    http://www.learnasp.com
    http://www.aspalliance.com
    http://www.haneng.com

    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)


  •  

    Posting Permissions

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