Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query SP parameters using ADO
Message
From
20/01/2003 14:18:51
 
 
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00743516
Message ID:
00743531
Views:
10
Is there a way to dynamically query parameters of a MSSQL stored proc using ADO?

You must use Command object to invoke SP. Use its Parameters collection to append parameters for input, output and result of SP. In MSDN, see "Parameter Object (ADO)" and "Parameters Collection (ADO)" topics.

Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)

VB (.NET) - what other language do you need in the whole Universe?...

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform