I have a 3-column SQL Server table that contains product data. I need an ASP.NET webpage that reads this data and dynamically renders a product catalog page.
Attached you will find a script to create the database table, a PowerPoint mockup of the product catalog I want, and a spreadsheet of test data should you require it.
## Deliverables
The attached database table contains three columns: Name, Category, and Introduction.
The default display of the product catalog website is a list of all unique values in the Category column, under the heading **Professional Development Library**. This is demonstrated in the first screen of the mockup.
The user will select a category, at which point a list of the names of all modules in that category (taken from the Name column) will display. This is demonstrated by clicking "Managed Healthcare" on the first screen of the mockup.
When the user clicks a module's name, the module's introduction (taken from the Introduction column) will display, under the heading **Overview**. This is demonstrated by clicking "Evaluating the Quality of Managed Care" on the second screen of the mockup.
There is also a list of breadcrumb links that displays underneath the top heading. This should be visible (and functional) on all pages below the main site.
Also attached, you will find a spreadsheet of sample data, should you find it useful. (Eventually all of that data will be scripted into the database table, but it hasn't been done yet.) If you need sample data for testing, please feel free to use this.
Other notes:
* As you can see in the sample data spreadsheet, a single module may be associated with multiple categories. This is fine, and the module should be listed in the catalog under ALL of the categories it is associated with.
* I will be customizing the aesthetics of the page ??" colors, fonts, backgrounds, etc. ??" in Visual Studio after the project is finished. Because of this, there's no need to make it pretty, as long as all the text you use can be modified. In other words, don't place text in images, and all will be well.
* The webpage should connect to the database using Windows authentication. I'll modify the connection string myself; just tell me where you put it.
* The finished version of this page will be running as a custom ASP control under SharePoint Server 2007. If you're aware of anything that needs to be done in order for that to work, or anything that might make it easier, by all means please let me know.
If you have any questions, please let me know. Thank you for your consideration.