sql = "update news set columnID=@columnID, title=@title,content=@content,description=@description,display=@display,Home=@Home,Recommand=@Recommand,ImageURL=@ImageURL,MainImage=@MainImage,addDate=@addDate,RuZhiDate=@RuZhiDate,FaBuDate=@FaBuDate,Remark1=@Remark1,Remark2=@Remark2,Remark3=@Remark3,Remark4=@Remark4,Remark6=@Remark6,Remark5=@Remark5,Remark7=@Remark7 where ID=@ID";
这是一条sql语句 接着我用SqlParameter全部赋值 但是运行时总报错(必须声明标量变量@Remark6)
arrop[0] = new SqlParameter("@columnID", Convert.ToInt32(strddlist1));
arrop[1] = new SqlParameter("@title", strtitleName);
arrop[2] = new SqlParameter("@content", strcontent);
arrop[3] = new SqlParameter("@description", strdesc);
arrop[4] = new SqlParameter("@display", strdisplay);
arrop[5] = new SqlParameter("@Home", strHome);
arrop[6] = new SqlParameter("@Recommand", strRecommand);
arrop[7] = new SqlParameter("@ImageURL", newName);
arrop[8] = new SqlParameter("@MainImage", newName1);
arrop[9] = new SqlParameter("@addDate", Convert.ToDateTime(strAddDate));
arrop[10] = new SqlParameter("@RuZhiDate",Convert.ToDateTime(datePX.Text));
arrop[11] = new SqlParameter("@Remark1", newName2);
arrop[12] = new SqlParameter("@Remark2", remark2);
arrop[13] = new SqlParameter("@Remark3", newName3);
arrop[14] = new SqlParameter("@Remark4", newName4);
arrop[15] = new SqlParameter("@FaBuDate", DateTime.Now);
arrop[16] = new SqlParameter("@Remark6", newName6);//没有声明Remark6
arrop[17] = new SqlParameter("@Remark5", Remark5.Text);
arrop[18] = new SqlParameter("@Remark7", newName7);