View Full Version : Database connection and searching

07-09-2002, 05:21 PM
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

07-09-2002, 10:18 PM
For Access connection:

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

07-10-2002, 01:45 AM
hi, here's something you may find helpful.

Letting users search for information (http://aspalliance.com/aspxtreme/ado/lettinguserssearchforinformation.aspx) :D

07-10-2002, 01:46 AM
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 (http://www.codingforums.com/showthread.php?s=&threadid=1691) thread), you might also want to check out these sites: