- Foxtable(狐表) (http://foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2)
---- 循环怎么执行SQL存储过程 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=151217)
-- 发布时间：2020/6/18 10:21:00
-- 循环怎么执行SQL存储过程
Dim l As String() = {"01","02","03","04"}
Dim ph As String ="A21293E"
Dim cmd As new SQLCommand
cmd.C
For Each i As String In l
cmd.CommandText="P_COPCH"
cmd.StoredProcedure= True
cmd.Parameters.Add(i,i)
cmd.Parameters.Add(i,ph)
cmd.ExecuteNonQuery()
Next
这样执行出错
这样执行出错-- 发布时间：2020/6/18 10:29:00
--
已解决，谢谢