下面发一个工整的:strInsert = "INSERT INTO product VALUES SET " +
"unit_id=?unit_id," +
"product_name=?product_name," +
"author_name=?author_name," +
"project_id=?project_id," +
"product_mode_id=?product_mode_id," +
"publish_range_id=?publish_range_id," +
"istranslated=?istranslated," +
"product_research_type_id=?product_research_type_id," +
"subject_id=?subject_id," +
"subject_2_id=?subject_2_id," +
"author_quality_id=?author_quality_id," +
"publish_unit=?publish_unit," +
"publish_date=?publish_date," +
"product_name_cn=?product_name_en," +
"project_name=?project_name," +
"cno=?cno," +
"keywords_en=?keywords_en," +
"keywords=?keywords," +
"apply_circs=?apply_circs," +
"word_number=?word_number," +
"product_abstract=?product_abstract," +
"electronic_file_sn=?electronic_file_sn," +
"electronic_file_sn2=?electronic_file_sn2," +
"electronic_file_sn3=?electronic_file_sn3," +
"electronic_file_memo=?electronic_file_memo";
cmd = new MySqlCommand(strInsert, con);//添加MySql变量
cmd.Parameters.Add("?unit_id", unit_id);
cmd.Parameters.Add("?product_name", product_name);
cmd.Parameters.Add("?author_name", author_name);
cmd.Parameters.Add("?project_id", project_id);
cmd.Parameters.Add("?product_mode_id", product_mode_id);
cmd.Parameters.Add("?publish_range_id", publish_range_id);
cmd.Parameters.Add("?istranslated", istranslated);
cmd.Parameters.Add("?product_research_type_id", product_research_type_id);
cmd.Parameters.Add("?publish_date", publish_date);
cmd.Parameters.Add("?product_name_en", product_name_en);
cmd.Parameters.Add("?project_name", project_name);
cmd.Parameters.Add("?cno", cno);
cmd.Parameters.Add("?keywords_en", keywords_en);
cmd.Parameters.Add("?keywords", keywords);
cmd.Parameters.Add("?apply_circs", apply_circs);
cmd.Parameters.Add("?word_number", word_number);
cmd.Parameters.Add("?product_abstract", product_abstract);
cmd.Parameters.Add("?electronic_file_sn", electronic_file_sn);
cmd.Parameters.Add("?electronic_file_sn2", electronic_file_sn2);
cmd.Parameters.Add("?electronic_file_sn3", electronic_file_sn3);
cmd.Parameters.Add("?electronic_file_memo", electronic_file_memo);
cmd.Parameters.Add("?subject_id", subject_id);
cmd.Parameters.Add("?subject_2_id", subject_2_id);
cmd.Parameters.Add("?author_quality_id", author_quality_id);
cmd.Parameters.Add("?publish_unit", publish_unit);