Topic – Creating an Interface

The purpose of this topic is simply to get you started in building an interface to your database. The examples here will use Visual Studio, but the principles of attaching to a database with any IDE will apply.

Reading

Required:

There is no required reading – the assignments will require you to work through the nuances and requirements of connecting to a database and writing code.

Reference:

http://msdn.microsoft.com/en-us/library/dd492171.aspx – This is a good getting started with Visual Studio tutorial with some fun games you can build.

http://www.youtube.com/playlist?list=PL6B7C261EA11622E3 – For VS 2010, this is buidling the Hello World application

For this topic you should have both SQL Server and Visual Studio installed on your machine. Version will not matter – for students the tools are available via https://www.dreamspark.com/

Lectures

Getting Started with Database Tools in Visual Studio – A video on connecting Visual Studio to SQL Server database

Calling Stored Procedures from Visual Studio 1 – How to call a stored procedure from within Visual Studio Code.

Adding Gridview to Input Screen – How to add a Gridview control to the input screen demonstrated in Calling Stored Procedures from Visual Studio 1

Assignments

Go to Assignments