Creating a visual web part
In this recipe, we will learn how to create a visual web part. The web part will show data from an external database in a grid format. For our recipe, we will make use of the AdventureWorks database.
Getting ready
For this recipe, you need to have access to the AdventureWorks database. You can download it from: http://msftdbprodsamples.codeplex.com/.
How to do it…
Launch your Visual Studio 2010 IDE as an administrator (right-click on the shortcut and select Run as administrator).
Select File | New | Project. The new project wizard dialog box will be displayed (make sure to select .NET Framework 3.5 in the top drop-down box).
Select Empty SharePoint Project under Visual C# | SharePoint | 2010 node from Installed Templates section on left-hand side.
Name the project EmployeeList and provide a directory location where you want to save the project and click on OK to proceed to the next step in the wizard.
By default, Visual Studio selects the SharePoint site available on the...
