Connecting to a Microsoft SQL server using the Visual Studio 2008 designer

For more videos on technology, visit http://www.Techytube.com
By Mike@Techytube

An inherently powerful feature in Visual Studio is the ability to create a SQL connection and manipulate data in the same fashion as adding components and controls to a project.

There is some debate on whether this method is better or worse than interacting strictly via the code, but it is an important feature that developers should know about, should they wish to use it.

In this video, I will use a sample database and table previously created, and show you how to create a SQL connection from scratch, a common error encountered during the process, and how to visually manipulate the data directly from your Windows Forms application, without the need for an external editor or administration tool.