Execute Stored Procedure from VB.Net App

[JulesDBQ]

I would like to execute an update stored procedure directly from my vb.net application. I am not providing any input parameters or returning a value. All I need it to do is run from the app.

I have looked through a bunch of the existing threads, but haven't been able to figure out what code I need to use. Does anyone have a code example that would point me in the right direction?

Thanks in advance.

 

[earthandfire]

Once you have defined your connection and command objects - command.executenonquery should do what you want


Hope this helps.

 

[Mastakilla]

command.commandtype = commandtype.storedprocedure
command.commandtext = storedProcedureName

command.executenonquery


hope it helps

 

[earthandfire]

Mastakilla -

Once you have defined your connection and command objects

 

[Mastakilla]

well maybe Jules needed more explaination..

He might even think my answer was to brief.


No offense, but you could have said, Once you have defined your connection and command objects, just execute the stored procedure.