Free C# Tutorials

home
Stay at Home and Learn

SQL Server Express and C# .NET

 
Computer Tutorials List

 

 

 

 

In this section, you'll learn how to create a database with SQL Server Express. You can do all this within the Visual C# .NET software. Once you have a database, you'll learn how to pull records from it, and display them on a Windows Form. You will also learn how to navigate through the records in your database, and how to add new records.

If you'd rather use Access as your database, then you can skip this section entirely. When you come to connect to a database, we'll show both ways of connecting - Access and SQL Server Express.


What is SQL Server Express?

SQL Server Express is database system from Microsoft. It's the stripped down version of SQL Server, which is used by a lot of big businesses around the world. Fortunately, Microsoft have made the Express Edition a free download.

Hopefully, you downloaded SQL Server Express with the Visual C# .NET Express Edition. If you did, you should see this somewhere on your start menu:

SQL Server on the Start Menu

If you can't see the SQL Server Express entry, then you'll need to download it. At the time of writing, the download location is here on the Microsoft site:

http://www.microsoft.com/sql/editions/express/default.mspx

The SQL Server Management Studio Express you can see in the image above is a separate download, and is piece of software that lets you create and manage your databases without starting up your Visual C# .NET software. You don't need to download it for this book. But if you want to grab it, go to the Microsoft site and type "SQL Server Management Studio Express" into the search box. We'd give you the location, but it's very long and messy. And anyway, they'll only change it!

Once you have downloaded and installed SQL Server Express, make sure it's up and running. Click the Configuration Tools menu above to see the following menu:

SQL Server Menu

Select SQL Server Configuration Manager and you should see a window appear:

The SQL Server Configuration Manager

In the right pane, make sure the State for both says Running. If not, right click and select Start from the menu. You can then close the Configuration Manager.

In the next lesson, you'll learn how to create a Database with SQL Server Express.

 

<-- Copy a File | Create a Database with SQL Server Express -->

<--Back to the C# .NET Contents Page

View all our Home Study Computer Courses