Loop Stored Procedure in VB.Net (win form)

Posted by Mo on Stack Overflow See other posts from Stack Overflow or by Mo
Published on 2010-04-28T14:09:04Z Indexed on 2010/04/28 14:13 UTC
Read the original article Hit count: 255

Filed under:
|
|
|
|

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

© Stack Overflow or respective owner

Related posts about sql

Related posts about vb.net