The project ASP.net project in c# that uses an SQL 2005 database to search for records based on location or keywords. The SQL 2005 database would contain records of listings that have keywords and a postcode (zipcode for location) Th asp.net page would simply contain two textboxes one for the search term (this can be any of the keywords or the listings business name) and a textpox for the location (the postcode/zipcode) The results would be sorted by how close the searched postcode was to the listings postcode or if no location/postcode was entered then there sorted by how close to the keywords. SQL 2005 schema all strings -business name -postcode -keywords What i want is a ASP.net search page, search results page and a listing page that dumps the SQL listing data onto a page. The listing page must also do a dump of the page to html and store it in a directory called pages. For example you view listingB the html markup sent from the server to the client must be saved on the server as [url removed, login to view] and save din pages/ directory if that page doers not already exist. it then must add a link to a sitemap file. The page must be fast and use caching. Somethings to consider if there are 100 listings will this slow the system? if you place it in a gridview canyou break up the sql commands? IT MUST be optimized for speed and performance!!!
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
ASP.NET c# SQL