How to create a database using c# code in .net 4.0

Question

0.00/5 (No votes)

See more:

Hi,

Using c# code, I have to check whether a database exists or not first and if it doesn't exists I have to create the database. And once DB exists then I need to create few tables using the c# code itself.

Please reply.

Thanks & Regards,
Mathi.

Posted 10-Oct-13 16:52pm

Mathi2code

Add a Solution

Comments

Ron Beyer 10-Oct-13 22:58pm

Alright, so what is your question? I see a lot of what you want to do, which is great, but nothing asking specific help. You also need to specify what database you are using.

Sushil Mate 10-Oct-13 23:38pm

Create Database in C#[^]

5 solutions

Solution 1

try this
http://support.microsoft.com/kb/307283[^]
http://www.c-sharpcorner.com/Forums/Thread/42411/[^]
Create an SQL Server Database Using C#[^]

Posted 10-Oct-13 18:21pm

bjdestiny

Solution 2

Hi,
Refer to these links may help you,
http://support.microsoft.com/kb/307283[^]
Create an SQL Server Database Using C#[^]

Posted 10-Oct-13 18:26pm

tanweer

Solution 3

like this

your connection string is like conn

C#

sqlcommand cmd = sqlcommand("create database your name",conn); 

conn.open();

cmd.excutenonquery();

it will automatically through error if database is already exists

and if database is not there it will create database.

same procedure for create tables also.

if any issue ask again.

Posted 10-Oct-13 18:43pm

Ashwani Gusain

Solution 5

Plz provide the needfull information so the solution can be provided.

Posted 10-Oct-13 20:45pm

durgesh j

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Renju Vinod · Accepted Answer · 2013-10-10T18:56:00

Hi,

Please check this.

Please change the bolded text

C#

string sqlCreateDBQuery;
    try
    {
        SqlConnection tmpConn = new SqlConnection("server=(local)\\SQLEXPRESS;Trusted_Connection=yes");

        sqlCreateDBQuery = "SELECT * FROM master.dbo.sysdatabases where name =
        \'Your db name\'";

        using (tmpConn)
        {
            tmpConn.Open();
            tmpConn.ChangeDatabase("master");

            using (SqlCommand sqlCmd = new SqlCommand(sqlCreateDBQuery, tmpConn))
            {
                int exists = sqlCmd.ExecuteNonQuery();

                if (exists <= 0)
                {
                   string script = your db creating sql script;
                   sqlCmd.ExecuteNonQuery(script);
                }
                else
                {
                   string script = your tables creating sql script;
                   sqlCmd.ExecuteNonQuery(script);
                }
            }
        }
    }
    catch (Exception ex) { }