2023年6月21日发(作者:)

必须声明标量变量错误 SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@LogNo", ),

new SqlParameter("@LogDate", ), new SqlParameter("@ItemAdvisor", ),

new SqlParameter("@ItemName", ), new SqlParameter("@WorkContent",), new SqlParameter("@NextWork",), new SqlParameter("@RiskEvaluation",), new SqlParameter("@TodayWorkload",), new SqlParameter("@CommonWorkload",), new SqlParameter("@OvertimeWorkload",), new SqlParameter("@SumWorkload",), new SqlParameter("@RemainderWorkload",), new SqlParameter("@Remarks",)}; strsql = "insert into bjcsjskj (logNo,logDate,itemAdvisor,itemName,workContent,nextWork,riskEvaluation,todayWorkload,commonWorkload,overtimeWorkload,sumWorkload,remainderWorkload,remarks,isExamineAndApprove) values('@LogNo','@LogDate','@ItemAdvisor','@ItemName','@WorkContent','@NextWork','@RiskEvaluation','@TodayWorkload','@CommonWorkload','@OvertimeWorkload','@SumWorkload','@RemainderWorkload','@Remarks','0')";

解决办法如下:将改成就可以了,也就是把ID定义为主键注意:DataKeyNames是⼀个数组,可以⽤多个字段组成主键(即关键字,唯⼀的,⽤来标识⼀条记录)。

2023年6月21日发(作者:)

必须声明标量变量错误 SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@LogNo", ),

new SqlParameter("@LogDate", ), new SqlParameter("@ItemAdvisor", ),

new SqlParameter("@ItemName", ), new SqlParameter("@WorkContent",), new SqlParameter("@NextWork",), new SqlParameter("@RiskEvaluation",), new SqlParameter("@TodayWorkload",), new SqlParameter("@CommonWorkload",), new SqlParameter("@OvertimeWorkload",), new SqlParameter("@SumWorkload",), new SqlParameter("@RemainderWorkload",), new SqlParameter("@Remarks",)}; strsql = "insert into bjcsjskj (logNo,logDate,itemAdvisor,itemName,workContent,nextWork,riskEvaluation,todayWorkload,commonWorkload,overtimeWorkload,sumWorkload,remainderWorkload,remarks,isExamineAndApprove) values('@LogNo','@LogDate','@ItemAdvisor','@ItemName','@WorkContent','@NextWork','@RiskEvaluation','@TodayWorkload','@CommonWorkload','@OvertimeWorkload','@SumWorkload','@RemainderWorkload','@Remarks','0')";

解决办法如下:将改成就可以了,也就是把ID定义为主键注意:DataKeyNames是⼀个数组,可以⽤多个字段组成主键(即关键字,唯⼀的,⽤来标识⼀条记录)。