Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search by Address

Status
Not open for further replies.

Padmajak

Programmer
Jun 7, 2008
10
Hi,

I need to develop a search engine functionality in c# that locates a martial arts schools near by .
I need to develop two types of search.

1. ZipCode + distance with in miles
2. Address + City and State.

I have a table in the sql database which has city, state, zipcode, lat and long values.

By using this information I was able to calculate a location of the schools by zip + distance.
I don't have any idea on how to search a school which is near to your address. All we have is that
data. Can anyone help me on this issue?
What type of information is needed (that means what data , columns needed in the database)
And also how to search ?

This is kind of very urgent.
I appreciate your help.
 
You will need to use the co-ordinates to perform the calculation. There are a few different ways of doing this, see here for some different methods:


You then just need to write your search page around the results.

Mark,

[URL unfurl="true"]http://lessthandot.com[/url] - Experts, Information, Ideas & Knowledge
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Website Design
[URL unfurl="true"]http://aspnetlibrary.com[/url] - An online resource for professional ASP.NET developers
 
Thank you Mark,

I have the database , but all we have is
Zipcode, city, state, Lat and Long. Our website runs fine for the zipcode.

We need to do a different search criteria by street address,
city , state

Where do we get the database that contains all the address information for cheap.

Thanks for your help.
 
Where do we get the database that contains all the address information for cheap.
Try searching Google as this is not at all related to ASP.NET.

Mark,

[URL unfurl="true"]http://lessthandot.com[/url] - Experts, Information, Ideas & Knowledge
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Website Design
[URL unfurl="true"]http://aspnetlibrary.com[/url] - An online resource for professional ASP.NET developers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top