Creating a database using Connector/NET Programming?

Question

How to create a database using connector/net programming? How come the following doesn't work?

    string connStr = "server=localhost;user=root;port=3306;password=mysql;";
    MySqlConnection conn = new MySqlConnection(connStr);
    MySqlCommand cmd;
    string s0;

    try
    {
        conn.Open();
        s0 = "CREATE DATABASE IF NOT EXISTS `hello`;";
        cmd = new MySqlCommand(s0, conn);
        conn.Close();
    }
    catch (Exception e)
    {
        Console.WriteLine(e.ToString());
    }

Darin Dimitrov · Accepted Answer · 2010-03-28 10:35:04Z

18

You need to execute the command and also make sure to properly dispose objects:

string connStr = "server=localhost;user=root;port=3306;password=mysql;";
using (var conn = new MySqlConnection(connStr))
using (var cmd = conn.CreateCommand())
{
    conn.Open();
    cmd.CommandText = "CREATE DATABASE IF NOT EXISTS `hello`;";
    cmd.ExecuteNonQuery();
}

answered Mar 28, 2010 at 10:35

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Frank_Vr Over a year ago

will this work in VS 2013 or do you have to attach a few Dll first?

Pbirkoff · Accepted Answer · 2010-03-28 10:31:04Z

16

You might want to execute the MySqlCommand. Now you just create one, but it doesn't execute your query.

Try this:

conn.Open();
s0 = "CREATE DATABASE IF NOT EXISTS `hello`;";
cmd = new MySqlCommand(s0, conn);
cmd.ExecuteNonQuery();
conn.Close();

answered Mar 28, 2010 at 10:31

Pbirkoff

4,7022 gold badges23 silver badges18 bronze badges

2 Comments

Frank_Vr Over a year ago

will this work in VS 2013 or do you have to attach a few Dll first?

MindRoasterMir Over a year ago

I tried this in my c# program but did not work. You must use ` rather than ' around the database name. Thanks

Ramgy Borja · Accepted Answer · 2017-06-26 02:53:03Z

execute your command and try this function

public void createDatabase(string server, string port, string database, string username, string password)
    {
        string connectionstring = string.Format("Server = {0}; Port ={1}; Uid = {2}; Pwd = {3}; pooling = true; Allow Zero Datetime = False; Min Pool Size = 0; Max Pool Size = 200; ", server, port, username, password);
        using (var con = new MySqlConnection { ConnectionString = connectionstring })
        {
            using (var command = new MySqlCommand { Connection = con })
            {
                if (con.State == ConnectionState.Open)
                    con.Close();

                try
                {
                    con.Open();
                }
                catch (MySqlException ex)
                {
                    msgErr(ex.Message + " connection error.");
                    return;
                }

                try
                {
                    command.CommandText = @"CREATE DATABASE IF NOT EXISTS @database";
                    command.Parameters.AddWithValue("@database", database);
                    command.ExecuteNonQuery();//Execute your command
                }
                catch (MySqlException ex)
                {
                    msgErr(ex.Message + " sql query error.");
                    return;
                }
            }
        }

    }

MindRoasterMir · Accepted Answer · 2020-08-03 13:45:45Z

-1

Imports MySql.Data.MySqlClient
Public Class Form1
    Private dBf As String = "Empresa"
    Private str As String = "Server = localhost; uid=root; pwd=;Database=mysql; pooling=false;"
    Private Cmd As MySqlCommand
    Private Con As New MySqlConnection(str)
    Private Sub Form1_Load() Handles MyBase.Load
        Try
            Con.Open()
            Cmd = New MySqlCommand("Create Database If Not exists " + dBf, Con)
            Cmd.ExecuteNonQuery() : Con.ChangeDatabase(dBf)
            Cmd = Con.CreateCommand
            Cmd.CommandText = "CREATE TABLE Empleado" &
             "(Id Char(10)  COLLATE utf8_spanish_ci Not Null," &
             "name  VarChar(50)  COLLATE utf8_spanish_ci Not Null," &
             "email VarChar(50)   COLLATE utf8_spanish_ci Not Null," &
             "website VarChar(50)  COLLATE utf8_spanish_ci Not Null," &
             "Primary Key(id)) ENGINE=MyISAM"
            Cmd.ExecuteNonQuery()
            MsgBox("Registros, ok!!!") : Con.Close()
        Catch ex As Exception
            MsgBox(Err.Description)
        End Try
    End Sub
End Class

edited Aug 3, 2020 at 13:45

MindRoasterMir

3801 gold badge3 silver badges20 bronze badges

answered Mar 31, 2018 at 21:46

Rafael

1

1 Comment

MindRoasterMir Over a year ago

There is no formatting. It does not help at all to solve the problem. Please remove or improve your answer thanks.

Collectives™ on Stack Overflow

Creating a database using Connector/NET Programming?

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related