Torna al Thread

MySql.Data.MySqlClient.MySqlCommand MySqlCmd = new MySql.Data.MySqlClient.MySqlCommand(); MySql.Data.MySqlClient.MySqlConnection conn = ectre.dblayer.config.Configuration.getIDBConnection("......."); MySqlCmd.Parameters.Clear(); MySqlCmd.CommandType = CommandType.Text; MySqlCmd.Connection = conn; MySqlCmd.CommandText = "INSERT INTO `mst_fpgm` (`DT_INS`, `MSG_INDEX`, `STATE`, `SENDER`, `RECIPIENT`, `QUEQUE`, `LIVE_TIME`, `CLASS`, `OPERATION`, `BODY`, `LINK_INFO`) VALUES (?DT_INS, ?MSG_INDEX, ?STATE, ?SENDER, ?RECIPIENT, ?QUEQUE, ?LIVE_TIME, ?CLASS, ?OPERATION, ?BODY, ?LINK_INFO);"; MySqlCmd.Parameters.Add("?DT_INS", MySql.Data.MySqlClient.MySqlDbType.Datetime).Value = DateTime.Now; ..... ..... ..... ..... MySqlCmd.Parameters.Add("?BODY", MySql.Data.MySqlClient.MySqlDbType.LongBlob).Value = System.Text.Encoding.Default.GetBytes(tst.ToString()); .... .... MySqlCmd.ExecuteNonQuery();
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5