Search by Address

[Padmajak]

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.

 

[ca8msm]

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:

http://forum.lessthandot.com/viewtopic.php?f=17&t=4659&p=26395

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

 

[Padmajak]

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.

 

[ca8msm]

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

 

[DavidKuhn0422]

Why don't you use Google Maps API

http://code.google.com/apis/maps/