Click here to Skip to main content
15,498,859 members
Articles / Database Development / SQL Server
Posted 25 Apr 2005


108 bookmarked

Create an SQL Server Database Using C#

Rate me:
Please Sign up or sign in to vote.
3.58/5 (41 votes)
24 Apr 2013CPOL
Create a SQL Server database using C#.

Image 1

This interface is akin to the SQL Server New Database menu.


In this presentation, I would like to show you how to create an SQL Server database using C#. Actually I had to deal with the problem when programming for our own specific DBMS.

First of all, you have to create a connection to the master database of your SQL Server to manipulate the new database (master is the database where you can get details about the whole DBMS).

Using the code

The code for creating the database is very simple, the main function can be listed as follows:

private void CreateDatabase(DatabaseParam DBParam)
    System.Data.SqlClient.SqlConnection tmpConn;
    string sqlCreateDBQuery;
    tmpConn = new SqlConnection();
    tmpConn.ConnectionString = "SERVER = " + DBParam.ServerName + 
                         "; DATABASE = master; User ID = sa; Pwd = sa";
    sqlCreateDBQuery = " CREATE DATABASE "
                       + DBParam.DatabaseName
                       + " ON PRIMARY " 
                       + " (NAME = " + DBParam.DataFileName +", "
                       + " FILENAME = '" + DBParam.DataPathName +"', " 
                       + " SIZE = 2MB,"
                       + " FILEGROWTH =" + DBParam.DataFileGrowth +") "
                       + " LOG ON (NAME =" + DBParam.LogFileName +", "
                       + " FILENAME = '" + DBParam.LogPathName + "', " 
                       + " SIZE = 1MB, "
                       + " FILEGROWTH =" + DBParam.LogFileGrowth +") ";
     SqlCommand myCommand = new SqlCommand(sqlCreateDBQuery, tmpConn);
         MessageBox.Show("Database has been created successfully!", 
                           "Create Database", MessageBoxButtons.OK, 
     catch (System.Exception ex)
         MessageBox.Show(ex.ToString(), "Create Database", 


You have to change the DBParam.ServerName to your appropriate SQL Server name.

Checking your results

To see the results, click on Enterprise Manager of SQL Server, click on the plus (+) next to your Server, click on (+) next to Database tab, and you can see the test DB.


Any comments or questions can be sent to:


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Web Developer
Vietnam Vietnam
I am Vietnamese. I am a researcher in Computer Science and a freelance translator in German and Vietnamese.
Willing to share experience!

Comments and Discussions

SuggestionBetter ways of doing this Pin
jim lahey24-Apr-13 5:56
Memberjim lahey24-Apr-13 5:56 
GeneralRe: Better ways of doing this Pin
Thomas Haller25-Apr-13 2:32
MemberThomas Haller25-Apr-13 2:32 
QuestionFolder in Program Folder Pin
cipristupi17-Jun-12 9:22
Membercipristupi17-Jun-12 9:22 
GeneralUpdate to use the program on network and some problems Pin
Egypt_Nemo26-Mar-12 18:56
MemberEgypt_Nemo26-Mar-12 18:56 
GeneralMy vote of 4 Pin
Niyazi Yarar6-Feb-12 1:03
MemberNiyazi Yarar6-Feb-12 1:03 
NewsConnection string!!! [modified] Pin
Tomasz Karlinski17-May-11 10:40
MemberTomasz Karlinski17-May-11 10:40 
Generaldont work Pin
priazma20-Mar-11 4:42
Memberpriazma20-Mar-11 4:42 
NewsMy vote of 1 Pin
Eddy Vluggen24-Apr-13 5:54
professionalEddy Vluggen24-Apr-13 5:54 
GeneralFreezing and not working. Pin
Serkan111-Jan-11 15:07
MemberSerkan111-Jan-11 15:07 
GeneralRe: Freezing and not working. Pin
Goransol16-Mar-11 13:02
MemberGoransol16-Mar-11 13:02 
GeneralRe: Freezing and not working. Pin
Eddy Vluggen24-Apr-13 5:53
professionalEddy Vluggen24-Apr-13 5:53 
GeneralRe: Freezing and not working. Pin
sw2437618-Nov-14 12:55
Membersw2437618-Nov-14 12:55 
GeneralMy vote of 4 Pin
aditya1989725-Dec-10 20:53
Memberaditya1989725-Dec-10 20:53 
GeneralVery Nice Pin
Jaffar Ramnad15-Dec-10 0:12
MemberJaffar Ramnad15-Dec-10 0:12 
GeneralMy vote of 2 Pin
jojokim21-Oct-10 8:29
Memberjojokim21-Oct-10 8:29 
GeneralNice Pin
rain_120-Aug-10 0:09
Memberrain_120-Aug-10 0:09 
GeneralRe: Nice Pin
Groulien22-Mar-11 4:39
MemberGroulien22-Mar-11 4:39 
GeneralNice one Pin
valeranavin2-May-10 21:33
Membervaleranavin2-May-10 21:33 
Generalthank you Pin
Rolf Böhlke26-Apr-10 11:54
MemberRolf Böhlke26-Apr-10 11:54 
GeneralGood article Pin
Donsw19-Jan-09 10:24
MemberDonsw19-Jan-09 10:24 
GeneralRe: Good article Pin
Member 31361519-Aug-09 11:39
MemberMember 31361519-Aug-09 11:39 
GeneralHelp.. Pin
BicycleTheif12-Nov-08 21:00
MemberBicycleTheif12-Nov-08 21:00 
General5 Stars Pin
Derek Bartram16-Apr-08 3:57
MemberDerek Bartram16-Apr-08 3:57 
QuestionHow to solve the error says An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in Additional information: System error. That is occur when i need to execute the stored procedure using C# Pin
Shiv524-May-06 20:58
MemberShiv524-May-06 20:58 
AnswerRe: How to solve the error says An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in Additional information: System error. That is occur when i need to execute the stored procedure using C# Pin
ardaolca14-Jan-09 2:06
Memberardaolca14-Jan-09 2:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.