.net mysql 参数_.NET中含有参数的mysql的写法

using(MySqlConnection mysqlConnection=newMySqlConnection(Properties.Settings.Default.connString))

{

mysqlConnection.Open();

MySqlTransaction mysqlTrans=mysqlConnection.BeginTransaction();stringstrsql="insert into t_record values(null,?details_id,?serial_num,?oper_person,?remark)";stringdetails_id="?details_id";stringserial_num="?serial_num";stringoper_person="?oper_person";stringremark="?remark";

MySqlParameter[] parms=newMySqlParameter[]

{newMySqlParameter(details_id,MySqlDbType.Int32,11),newMySqlParameter(serial_num,MySqlDbType.VarChar,20),newMySqlParameter(oper_person,MySqlDbType.VarChar,20),newMySqlParameter(remark,MySqlDbType.VarChar,50),

};

parms[0].Value=15;

parms[1].Value=SerialNum;

parms[2].Value="liush";

parms[3].Value="未包含可扫描的序列号";

MySqlCommand mysqlcmd=newMySqlCommand();

mysqlcmd.Connection=mysqlConnection;

mysqlcmd.CommandType=CommandType.Text;

mysqlcmd.CommandText=strsql;

mysqlcmd.Transaction=mysqlTrans;foreach(MySqlParameter praminparms)

mysqlcmd.Parameters.Add(pram);

mysqlcmd.ExecuteNonQuery();

mysqlTrans.Commit();

}