Create sample VS2008 project in C#, target .Net 3.5.
Store a connection for an SQL 2008 Database in the webconfig.
Create an ASPX page that has two list boxes.
The first list box (Object Type) will display the following 4 items:
Table
View
Stored Procedure
SQL Function
The second list box (SQL Object) will retrieve from the database the SQL objects that match based on what was selected in the first list box.
The page should use ajax like methodology so the page does not resubmit but just refreshes within the page.
When the second list box gets a value selected, it should display the object code and properly formatted with the syntax code highligher. Developer must use the Activpro ASPX Syntax code highligher.
(<[login to view URL]>)
The list box controls should be done with the 10.2.x series of DeveloperExrepss web controls.
Use the AdventureWorks database a sample for creating the project.
The deliverable is the Visual Studio Project created, plus the stored procedure(s) in a zip file.