Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to call a stored procedure?
Message
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
00641043
Message ID:
00641171
Views:
12
>How do you call a stored procedure in VB.NET? Also, I haven't done this before, but someone told me that you can attach a stored procedure to a connection object and run it just like a method. How is this possible? Is there a design interface that shows this? Where is this interface? Thanks for the help.

VFP or SQL Server?
SP returns rows or just a single value?

If your stored proc doesn't return any rows you can run ExecuteNonQuery of the Command Object.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdadotnetdata1.asp
maybe thats what they were talking about? Of course you can create your own Data Access component and make up your own method that calls the stored procedure.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform