Création d’une firebase database à l’aide de Connector / NET Programming?

Comment créer une firebase database en utilisant la programmation connecteur / net? Comment se fait-il que ce qui suit ne fonctionne pas?

ssortingng connStr = "server=localhost;user=root;port=3306;password=mysql;"; MySqlConnection conn = new MySqlConnection(connStr); MySqlCommand cmd; ssortingng s0; try { conn.Open(); s0 = "CREATE DATABASE IF NOT EXISTS `hello`;"; cmd = new MySqlCommand(s0, conn); conn.Close(); } catch (Exception e) { Console.WriteLine(e.ToSsortingng()); }

Vous voudrez peut-être exécuter MySqlCommand. Maintenant, vous en créez un, mais votre requête n’est pas exécutée.

Essaye ça:

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

Vous devez exécuter la commande et vous assurer de disposer correctement des objects:

 ssortingng 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(); }

exécuter votre commande et essayer cette fonction

 public void createDatabase(ssortingng server, ssortingng port, ssortingng database, ssortingng username, ssortingng password) { ssortingng connectionssortingng = ssortingng.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 { ConnectionSsortingng = connectionssortingng }) { 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; } } } }

Importe MySql.Data.MySqlClient Classe publique Private Form1 Private dBf As Ssortingng = “Empresa” Private str As Ssortingng = “Serveur = localhost; uid = root; pwd =; Base de données = mysql; pooling = false;” Private Cmd As MySqlCommand Private Con Comme New MySqlConnection (str) Private Sub Form1_Load () gère MyBase.Load Essayez Con.Open () Cmd = New MySqlCommand (“Créer une firebase database s’il n’existe pas” + dBf, Con) Cmd.ExecuteNonQuery (): Con.ChangeDatabase (dBf) Cmd = Con.CreateCommand Cmd.CommandText = “CREATE TABLE Empleado” & “(Id Char (10) COLLATE utf8_spanish_ci Non Null,” & “nom VarChar (50) COLLATE utf8_spanish_ci Non Null,” & “email VarChar (50) COLLATE utf8_spanish_ci Non Null, “&” site Web VarChar (50) COLLATE utf8_spanish_ci Non Null, “&” Clé primaire (id)) ENGINE = MyISAM “Cmd.ExecuteNonQuery () MsgBox (” Registros, ok !!! ” ): Con.Close () Catch ex As Exception MsgBox (Err.Description) End Try End End End Class