ado的mysql参数化_“必须使用ADO参数化查询声明变量@myvariable”错误

使用Parameters.AddWithValue，如下所示

connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Jet OLEDB:Database Password=RainbowTrout;";

InsertQry = "Insert into Sections(Name, PartNumber, VersionNumber, Channel, Address, Status, IPAddr) "

+ "values(@SectionName, @PartNumber, @VersionNumber, @Channel, @Address, @Status, @IPAddr)";

NewCfgConnection.ConnectionString = string.Format(connectionString, ConfigFN);

NewCfgCommand.Connection = NewCfgConnection;

NewCfgCommand.CommandText = InsertQry;

NewCfgConnection.Open();

// Clear parameter values from last record

NewCfgCommand.Parameters.Clear();

// Insert record into sections table - set parameters

NewCfgCommand.Parameters.AddWithValue("@SectionName", sSectionName);

NewCfgCommand.Parameters.AddWithValue("@PartNumber", sPartNumber);

NewCfgCommand.Parameters.AddWithValue("@VersionNumber", sVersionNumber);

NewCfgCommand.Parameters.AddWithValue("@Channel", iChannel);

NewCfgCommand.Parameters.AddWithValue("@Address", iAddress);

NewCfgCommand.Parameters.AddWithValue("@Status", iStatus);

NewCfgCommand.Parameters.AddWithValue("@IPAddr", iIP);

NewCfgCommand.ExecuteNonQuery();