How do I connect my ASP.NET project to the AdventureWorksLT database?

Establishing database connections to SQL Server 2005 is pretty straight forward, provided that you have the necessary components:

• SQL Server 2005 Express
• Visual Web Developer 2008 Express
• Microsoft SQL Server Management Studio Express

Read the rest of this entry »

How do I install the AdventureWorks sample database with SQL Server 2005 Express?

File Download:

1. Navigate to: http://www.codeplex.com/MSFTDBProdSamples.
2. From the: Releases tab, click: SQL Server 2005 (hyperlink).
3. Scroll down and click: AdventureWorksLT.msi.
4. Save the file to your desktop or other known location.
5. Once the download is complete, click: Run (or navigate to the location where you saved the file and double-click: AdventureWorksLT.msi) to start the install.
6. Follow the prompts (using the default selections) to complete the install.

Read the rest of this entry »