Hi,

Please can someone give me the code to execute a stored procedure by click of a command button ?
In Detail :
I have a combo box that displays all the online databases in a SQL server. I have a button "Backup" on my form.
When I choose one of the databases and click on the command button the chosen database needs to be backed up. I have the stored procedure which does the back up but not sure how to invoke it by click of the button.

Please help.

Thanks in Advance.
Vidya.

Hi,

Write code likes this in the click event

'Declare connectionstring'
'Declare connection'

'Declare command-object like this'

Dim objcommand as new sqlcommand(or oledbcommand)
objcommand.commandtype= commandtype.storedprocedure

'connection open'

objcommand.executenonquery("name of stored procedure")

'connection close'

That should do it !

I suppose your procedure knows which of the databases to backup !
Otherwise we are talking about a stored procedure with a parameter, and that takes a litte more code.

Regards

Finn