using System.Data.SqlClient; SqlConnection SQLConn = new SqlConnection(); SQLConn.ConnectionString="Server=localhost;InitialCatalog=myBdd;uid=myLogin;password=password"; SQLConn.Open(); string cmd = "INSERT INTO Equipes SET " + "IDeqp='" + Eqp.Numero.ToString() + "'," + "Nomeqp='" + Eqp.Nom_Eqp + "'," + "Nom1='" + Eqp.Nom1+ "'," + "Nom2=" + Eqp.Nom2+ "," + "Nom3='" + Eqp.Nom3+ "'," + "Nom4='" + Eqp.Nom4+ "'"; SqlCommand command = new SqlCommand(cmd, connection); command.ExecuteNonQuery(); connection.Close();
string sMyConnSQL = "SERVER=localhost;DATABASE=MaDataBase;UID=root;PASSWORD=password;"; MySqlConnection connection = new MySqlConnection(sMyConnSQL); connection.ConnectionString = sMyConnSQL; connection.Open(); string cmd = "INSERT INTO Equipes SET " + "IDeqp='" + Eqp.Numero.ToString() + "'," + "Nomeqp='" + Eqp.Nom_Eqp + "'," + "Nom1='" + Eqp.Nom1+ "'," + "Nom2=" + Eqp.Nom2+ "," + "Nom3='" + Eqp.Nom3+ "'," + "Nom4='" + Eqp.Nom4+ "'"; MySqlCommand command = new MySqlCommand(cmd, connection); command.ExecuteNonQuery(); connection.Close();
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question