1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| public int EDOUARDInsertMain(DateTime Date, double Bid, double Ask, string NomEme)
{
if (db.getDbUp())
{
MySqlParameter paramDate = new MySqlParameter("@Date", MySqlDbType.DateTime);
paramDate.Value = Date;
MySqlParameter paramBid = new MySqlParameter("@Bid", MySqlDbType.Double);
paramBid.Value = Bid;
MySqlParameter paramAsk = new MySqlParameter("@Ask", MySqlDbType.Double);
paramAsk.Value = Ask;
MySqlParameter paramNomEme = new MySqlParameter("@NomEme", MySqlDbType.String);
paramNomEme.Value = NomEme;
String strQuery = string.Format("INSERT INTO ma09b (DateRecep,Bid,Ask,NomEme) VALUES ( {0} , {1}, {2} , {3})",
paramDate.ParameterName,paramBid.ParameterName,paramAsk.ParameterName,paramNomEme.ParameterName);
MySqlCommand oCommand = new MySqlCommand(strQuery.ToString(), db.getConnectionRessource());
oCommand.Parameters.Add(paramDate);
oCommand.Parameters.Add(paramBid);
oCommand.Parameters.Add(paramAsk);
oCommand.Parameters.Add(paramNomEme);
return oCommand.ExecuteNonQuery();
}
else
{
Console.WriteLine("Base non connectée.");
return 0;
}
} |
Partager