Find Jobs
Hire Freelancers

ASP .NET SQL database query app

$100-200 USD

Completed
Posted almost 19 years ago

$100-200 USD

Paid on delivery
This will be an .ASP .NET application that queries a SQL database. The database contains records of my beer bottle and can collection. I currently have an Access database and .ASP application, and I want the database converted to SQL and a new application written that will be easier to use and offer new features such as displaying images of each item and other information. The application will be based around the main page that will allow the user to query the database and also display other factual statistics and interesting information from the database. The GUI look of the application is important: it should be clean, professional, and easy to use. It should look interesting without looking cluttered. My goal is to have an application that will hold peoples’ attention for a few minutes. While there are specific requirements for this application, I am looking for a coder who can make suggestions on other possible features and possibly provide input about different or better ways to do things. I currently have an Access database with 2300 records that will need to be converted to SQL ## Deliverables **Main page** The .ASP application will consist of a main web page that does several things: - Allows the user to query the SQL database for records that meet specific requirements. The user will select from a drop-down list of available fields, and then type in a string to search for. Available fields will include: beer name, brewery name, country, region, date entered, container size, and beer style. - Displays the database search results and links to navigate through the results page by page. The page will also have areas where other additional information is displayed: - Displays the top 5 search terms (strings) - Displays the top 5 most displayed database records by beer name. The displayed beer names are hyperlinks that cause that record to be displayed in the search results area of the screen. - Displays a random beer bottle name and its photo from the database - Displays the 5 or 10 most recent database entries by beer name. The displayed beer names are hyperlinks that cause that record to be displayed in the search results area of the screen. - Display other statistical data: Country with the most records, largest bottle, smallest bottle, etc. Clicking on any of these would return the full record (or records) in the search results area of the page. **Query logic** When the database is queried, the application will conform to these requirements: - Wildcards are allowed. For example searching for smith* returns all records with smith at the beginning of the string. - Entering only * as a search string will return all records. - Seaching for smith+hill returns all records that contain the strings smith and hill. **Existing database** The database currently consists of an Access DB with a single table and about a dozen fields. It contains about 2300 records. This will need to be imported to SQL. Additional fields or tables may need to be added to accommodate the needs of the application. The existing most important fields in the database are: beer name, brewery name, beer style (stout, pilsner, pale ale, etc), date entered, bottle size, type of cap, country of brewery, region of brewery, location where item was acquired. The database is currently online at this address, but without photos or any other features: [login to view URL] **Images** When search results are returned to the user, a thumbnail image will be displayed with each result. Results will be displayed in a traditional tabular or grid format. Each thumbnail image will be clickable, and clicking it opens the large version of that photo in a new window. All images will be stored in the file system, and there will be both a thumbnail and a full-size version of each image. Image filenames will correspond to the database unique ID of each record. For example, the images for record #1001 would be [login to view URL] and 1001t.jpg. The path (location) of the images files would be specified in the .asp code and should be easily editable. Thumbnail images would be roughly 60x125 (width x height) pixels in size, but this can be changed to meet the needs of the layout of the page. Some images are here: <[login to view URL]>** Navigating the database query results** When entering a database query, the user will choose from a drop-down box how many records are to be retuned per page: 5, 10, or 20. The application will default to 10 records per page if nothing is selected. If multiple pages of records are returned, then the user will page through the records by a series of links to pick a particular page number, next page, or previous page. For example: < 1 2 3 4 5 > If more than 10 *pages* of records are available, then the user would see a link that says “Next group of 10??: < 1 2 3 4 5 6 7 8 9 10 > (Next group) When clicking on the “next group?? link, the application would return the first page in the next set of records. For example, if I searched for a term that returned 400 records and told the app to display 10 records per page, there would be 40 pages of data that could possibly be displayed. Immediately after searching, the app would show me: < 1 2 3 4 5 6 7 8 9 10 > (Next group) And I could click on ‘next group’ and I’d see page 11 of the results and the navigation bar would look like this: < 11 12 13 14 15 16 17 18 19 20 > (Next group) (11 would not be a hyperlink because I’m already on that page) These links should appear at the top and bottom of the list of displayed records. This whole navigation bar scheme might be done better if you have thoughts about a different way to do it. Your input is welcome! **Graphic look of the application** Extra consideration will be given for individuals who have expertise in creating attractive and professional-looking interfaces. The GUI should look attractive, uncluttered, and be intuitive and easy to navigate. The use of graphic elements to create an attractive page is great; however a plain HTML layout would be acceptable if it looks attractive and uncluttered. All fonts should be Arial (or equivalent). Font size should be small: 1 or 2, or use a combination as long as it looks appropriate. One example might be to display the DB query results in a small font, but the rest of the page would use a larger font. Here is a rough sketch of what I'm looking for. The actual layout may be some what different depending on the size of all of the individual elements: <[login to view URL]> **Technology and coding** The application will be written in Microsoft .ASP .NET and use a SQL 2000 database. The .ASP application will be hosted on Windows 2003 with IIS6 using MSDE 2000. The code should be well documented internally, non-encrypted, and easy to modify. “Easy to modify?? means that the design of the code and layout of the GUI should be such that features can be added to the application in the future, such as displaying a random quote, various statistics from the database, random link, random ‘beer fact of the day’, or links to other websites. If I really like the finished app, it is possible that I would ask you to write these additional features in the future as a second, paid job. **Other ideas** Extra consideration will be given for individuals who have additional ideas that might make this application easier to use or present interesting data to the user. I have a good idea of what I want this application to do, however it’s highly likely that someone else will have some great ideas about how the application can be improved upon. Your ideas are appreciated. -- 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. 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). ## Platform The application will be written in Microsoft .ASP .NET and use a SQL 2000 database. The .ASP application will be hosted on Windows 2003 with IIS6 using MSDE 2000. I host this server myself, and have full control over all of the IIS settings, filesystem, etc. The app should display correctly in IE 6+ and Firefox
Project ID: 3778283

About the project

19 proposals
Remote project
Active 19 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$170 USD in 35 days
4.2 (2 reviews)
2.7
2.7
19 freelancers are bidding on average $143 USD for this job
User Avatar
See private message.
$169.15 USD in 35 days
4.6 (268 reviews)
7.8
7.8
User Avatar
See private message.
$127.50 USD in 35 days
4.9 (56 reviews)
5.7
5.7
User Avatar
See private message.
$127.50 USD in 35 days
5.0 (74 reviews)
5.2
5.2
User Avatar
See private message.
$127.50 USD in 35 days
5.0 (54 reviews)
5.2
5.2
User Avatar
See private message.
$170 USD in 35 days
5.0 (18 reviews)
4.9
4.9
User Avatar
See private message.
$127.50 USD in 35 days
4.9 (27 reviews)
4.6
4.6
User Avatar
See private message.
$144.50 USD in 35 days
4.0 (11 reviews)
4.6
4.6
User Avatar
See private message.
$127.50 USD in 35 days
3.8 (23 reviews)
4.2
4.2
User Avatar
See private message.
$170 USD in 35 days
5.0 (7 reviews)
3.9
3.9
User Avatar
See private message.
$170 USD in 35 days
4.3 (7 reviews)
3.7
3.7
User Avatar
See private message.
$127.50 USD in 35 days
4.3 (3 reviews)
3.4
3.4
User Avatar
See private message.
$170 USD in 35 days
5.0 (6 reviews)
1.9
1.9
User Avatar
See private message.
$127.50 USD in 35 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$85 USD in 35 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$170 USD in 35 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$127.50 USD in 35 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$170 USD in 35 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$102 USD in 35 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
1
Member since Jan 28, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.