更新语句

[bj_kevin51]

   allsql = "update  WS_DangerousSource set " +
                 "  DangerousSourceName = '" + dt.Rows[i]["DangerousSourceName"].ToString() + "' , " +
                  "DangerousPointCode   = '" + dt.Rows[i]["DangerousPointCode"].ToString() + "'  , " +
                  "WorkingInstruction   = '" + dt.Rows[i]["WorkingInstruction"].ToString() + "'  , " +
                  "WorkingName   = '" + dt.Rows[i]["WorkingName"].ToString() + "'  , " +
                   "DepCode   = '" + dt.Rows[i]["DepCode"].ToString() + "'  , " +
                     "ActiveType   = '" + dt.Rows[i]["ActiveType"].ToString() + "'  , " +
               "LeadConsequences   = '" + dt.Rows[i]["LeadConsequences"].ToString() + "'  , " +
                "CramerPoints_L   = '" + dt.Rows[i]["CramerPoints_L"].ToString() + "'  , " +
                "CramerPoints_E   = '" + dt.Rows[i]["CramerPoints_E"].ToString() + "'  , " +
               "CramerPoints_C   = '" + dt.Rows[i]["CramerPoints_C"].ToString() + "'  , " +
                "CramerPoints_D   = '" + dt.Rows[i]["CramerPoints_D"].ToString() + "'  , " +

这样用Datatable中查询出的数据更新有错误么？
他提示我：＋号左面的必须是变量、属性和索引器！

[bancxc]

输出sql语句 到查询分析器执行一下看看

[soft_wsx]

[Quote=引用 1 楼 bancxc 的回复:]
输出sql语句 到查询分析器执行一下看看
[/Quote]试下先

[让你望见影子的墙]

C# 的？
看看增加参数怎么增加

[soft_wsx]

顶

[小宏]

顶

[yander]

如何输出sql语句到查询分析器？