Loop Stored Procedure in VB.Net (win form)

Question

Hello,

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 tried the SP and it works perfectly in SQLServer

Answer 1

Third parameter is bad, should be:

objDL.BackupTables(220, i, 1)