English 中文(简体)
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 tried the SP and it works perfectly in SQLServer

问题回答

Third parameter is bad, should be:

objDL.BackupTables(220, i, 1)




相关问题
Bring window to foreground after Mutex fails

I was wondering if someone can tell me what would be the best way to bring my application to the foreground if a mutex was not able to be created for a new instance. E.g.: Application X is running ...

How to start WinForm app minimized to tray?

I ve successfully created an app that minimizes to the tray using a NotifyIcon. When the form is manually closed it is successfully hidden from the desktop, taskbar, and alt-tab. The problem occurs ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

Handle DataTable.DataRow cell change event

I have a DataTable that has several DataColumns and DataRow. Now i would like to handle an event when cell of this DataRow is changed. How to do this in c#?

Apparent Memory Leak in DataGridView

How do you force a DataGridView to release its reference to a bound DataSet? We have a rather large dataset being displayed in a DataGridView and noticed that resources were not being freed after the ...

ALT Key Shortcuts Hidden

I am using VS2008 and creating forms. By default, the underscore of the character in a textbox when using an ampersand is not shown when I run the application. ex. "&Goto Here" is not ...

WPF-XAML window in Winforms Application

I have a Winforms application coded in VS C# 2008 and want to insert a WPF window into the window pane of Winforms application. Could you explain me how this is done.

热门标签