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
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:
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:
Select SQL Server Configuration Manager and you should see a window
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
In the next lesson, you'll learn how to create a Database with SQL
<-- Copy a File |
Create a Database with SQL Server Express
<--Back to the C# .NET Contents
View all our Home Study Computer