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 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
| SqlConnection maConnexionSQLsrv;
SqlCommand myCommand;
String ConnexionSQL;
//Récupération de la chaine de connexion au serveur de base de données
ConnexionSQL = @"Data Source=SRVSQL2\DEV;Initial Catalog=ATE_Results;User ID=sa;Password=sadevpass";
maConnexionSQLsrv = new SqlConnection(ConnexionSQL);
String queryResultSessionLap = "INSERT INTO ResultSessionLap ";
queryResultSessionLap += " (idsResultSession, lngCycle, lngLapNumber, dtmTestStart, dtmTestEnd, blnECEnable, strECMode, dblECTemperature, intECSegment, blnAllTest, ";
queryResultSessionLap += " blnSuccess) ";
queryResultSessionLap += " VALUES (@idsResultSession,@lngCycle, @lngLapNumber, @dtmTestStart, ";
queryResultSessionLap += " @dtmTestEnd, @blnECEnable, @strECMode, @dblECTemperature, @intECSegment, @blnAllTest, @blnSuccess)";
myCommand = new SqlCommand(queryResultSessionLap, maConnexionSQLsrv);
//Parameters
myCommand.Parameters.Add(new SqlParameter("@idsResultSession", SqlDbType.Int, 4));
myCommand.Parameters.Add(new SqlParameter("@lngCycle", SqlDbType.Int, 4));
myCommand.Parameters.Add(new SqlParameter("@lngLapNumber", SqlDbType.Int, 4));
myCommand.Parameters.Add(new SqlParameter("@dtmTestStart", SqlDbType.DateTime, 32));
myCommand.Parameters.Add(new SqlParameter("@dtmTestEnd", SqlDbType.DateTime, 32));
myCommand.Parameters.Add(new SqlParameter("@blnECEnable", SqlDbType.Bit, 4));
myCommand.Parameters.Add(new SqlParameter("@strECMode", SqlDbType.NVarChar, 255));
myCommand.Parameters.Add(new SqlParameter("@dblECTemperature", SqlDbType.Float, 25));
myCommand.Parameters.Add(new SqlParameter("@intECSegment", SqlDbType.SmallInt, 4));
myCommand.Parameters.Add(new SqlParameter("@blnAllTest", SqlDbType.Bit, 8));
myCommand.Parameters.Add(new SqlParameter("@blnSuccess", SqlDbType.Bit, 25));
//Parameters initialization
myCommand.Parameters["@idsResultSession"].Value = Convert.ToInt32(iParameter["idsResultSession"]);
myCommand.Parameters["@lngCycle"].Value = Convert.ToInt32(iParameter["lngCycle"]);
myCommand.Parameters["@lngLapNumber"].Value = Convert.ToInt32(iParameter["lngLapNumber"]);
myCommand.Parameters["@dtmTestStart"].Value = Convert.ToDateTime(iParameter["dtmTestStart"]);
myCommand.Parameters["@dtmTestEnd"].Value = Convert.ToDateTime(iParameter["dtmTestEnd"]);
myCommand.Parameters["@blnECEnable"].Value = Convert.ToByte(iParameter["blnECEnable"]);
myCommand.Parameters["@strECMode"].Value = Convert.ToString(iParameter["strECMode"]);
myCommand.Parameters["@dblECTemperature"].Value = Convert.ToDouble(iParameter["dblECTemperature"]);
myCommand.Parameters["@intECSegment"].Value = Convert.ToInt32(iParameter["intECSegment"]);
myCommand.Parameters["@blnAllTest"].Value = Convert.ToByte(iParameter["blnAllTest"]);
myCommand.Parameters["@blnSuccess"].Value = Convert.ToByte(iParameter["blnSuccess"]);
try
{
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
catch (SqlException ex)
{
Console.WriteLine("Ex: " + ex); // shows exception message in console if any errors occured
} |
Partager