SqlCommandBuilder产生的UpdateCommand莫名其妙
高手指点,只有10分,代码如下:
myBuild.DataAdapter = da;
comm.CommandText = "SELECT ID_DEPT,ID_PARA,NO_DEPT,NM_DEPT FROM BS_DEPT "; //ID_DEPT是主键
da.SelectCommand = comm;
da.UpdateCommand = myBuild.GetUpdateCommand();
然后跟踪得到的竟是
UPDATE [BS_DEPT] SET [ID_PARA] = @p1, [NO_DEPT] = @p2, [NM_DEPT] = @p3 WHERE (([ID_DEPT] = @p4) AND ((@p5 = 1 AND [ID_PARA] IS NULL) OR ([ID_PARA] = @p6)) AND ((@p7 = 1 AND [NO_DEPT] IS NULL) OR ([NO_DEPT] = @p8)) AND ((@p9 = 1 AND [NM_DEPT] IS NULL) OR ([NM_DEPT] = @p10)))
应该是
UPDATE [BS_DEPT] SET [ID_PARA] = @p1, [NO_DEPT] = @p2, [NM_DEPT] = @p3 WHERE ([ID_DEPT] = @p4)才对呀
[解决办法]
自动生成是比较所有的字段,你可以手动赋于SQL
