How do you call a stored procedure from Visual Basic using ADO? How do you pass the parameters to the Stored Procedure?
Printable View
How do you call a stored procedure from Visual Basic using ADO? How do you pass the parameters to the Stored Procedure?
Use a command object. Use the parameters.append method to add the input (and output) parms.
I advise you to get the book:
HitchHiker's Guide to Visual Basic and SQL Server by William Vaughn (at least the sixth edition. Any earlier than sixth has little or no information on ADO) - ISBN 1-57231-848-1