开发者

Loop Stored Procedure in VB.Net (win form)

I am trying to run a for loop for a backup system and inside that i want to run a SP that will loop. Below is the code that does not work for me..

Any ideas please?

Dim TotalTables As Integer
Dim i As Integer

TotalTables = 10
  For i = 1 To TotalTables
 objDL.BackupTables(220, i, 001) ' (This is a method from the DL and the 3 parameters are integars)
 Next

I tr开发者_如何学Pythonied the SP and it works perfectly in SQLServer


Third parameter is bad, should be:

objDL.BackupTables(220, i, 1)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜