How to Connect Microsoft SQL Server with Microsoft Visual Studio

This is a video on How to connect Microsoft SQL Server with Microsoft Visual Studio

The Code which I copy-pasted (Only copy-pasted part)-http://pastebin.com/8xicu6dk

Whole code of the project-http://pastebin.com/jvQsTb5K

I have used Microsoft Visula Studio 2010 and Microsoft SQL Server 2008 in this video , but the video should work in any other versions.

SQL Server Management Studio Download Link-http://www.microsoft.com/en-us/download/details.aspx?id=22973#QuickDetails

Microsoft Visual Studio Download Link – http://www.visualstudio.com/downloads/download-visual-studio-vs