OleDbParameter[] par ={
new OleDbParameter("@proName", OleDbType.LongVarChar),
new OleDbParameter("@proNO", OleDbType.LongVarChar)
};
par[0].Value=image + dr2["题干"].ToString();
par[1].Value = dr2["题号"].ToString();
string updatetimuStr = "update [" + dr["xiaolei"].ToString().Trim() + "] set 题干=@proName where 题号=@proNO";
OleDbCommand cmd8 = new OleDbCommand(updatetimuStr, conn);
cmd8.ExecuteNonQuery();
错误提示:至少一个参数没有被指定值跟踪了一下 updatetimuStr 里面是 update [第十五章 神经系统疾病] set 题干=@proName where 题号=@proNO
OleDbCommand cmd8 = new OleDbCommand(updatetimuStr, conn,par);par位置不记得了,自己弄进去吧。
OleDbCommand cmd8 = new OleDbCommand(updatetimuStr, conn);
cmd8.Parameters.Add(par );
cmd8.ExecuteNonQuery();
OleDbCommand cmd8 = new OleDbCommand(updatetimuStr, conn);
cmd8.Parameters.Add(par );
cmd8.ExecuteNonQuery();
cmd8.Parameters.AddRange(par );