120-C# Developer: SQL Server - Create Database and Tables | Practice

Create a SQL Server Database programmatically by using ADO.NET and Visual C# .NET
This step-by-step article shows you how to create a Microsoft SQL Server database by using ADO.NET and Visual C# .NET because programmers often need to create Databases programmatically.

For a Microsoft Visual Basic .NET version of this article, see How to create a SQL Server database programmatically by using ADO.NET and Visual Basic .NET.

For a Microsoft Visual C++ .NET version of this article, see How To Create a SQL Server Database Programmatically by Using ADO.NET and Visual C++ .NET.

This article refers to the following Microsoft .NET Framework Class Library namespace: System.Data.SqlClient.
Steps to create a SQL Server Database

To create the database, follow these steps:

Create a new Visual C# .NET Windows application.

Place a button on Form1. Change the button's Name property to btnCreateDatabase, and then change the Text property to Create Database.

Use the using statement on the System and System.Data namespaces so that you do not have to qualify declarations in those namespaces later in your code. Add the following code to the General Declarations section of Form1.
In this article, you are going to learn about how to perform basic database operations using system.data.SqlClient namespace in C#. The basic operations are INSERT, UPDATE, SELECT and DELETE. Although the target database system is SQL Server Database, the same techniques can be applied to other database systems because the query syntax used is standard SQL that is generally supported by all relational database systems.