How to call a Parametrised Stored procedure from VB

[AbhiDesh]

hi
i want to call a stored procedure with 3 in parameters and one out parameter of SQL Server 7.

i have called a procedure with out parameters.

if any one can help try out this....

Thanks,
AbhiDesh

[forkirun]

hi.. here it is ....


Dim cmdAddProperty as new ADODB.Command
Dim Params(1 to 3) as Variant
With cmdAddProperty
.CommandType = adCmdStoredProc
.CommandText = "SPAddProperty"
.ActiveConnection = Con
End With
Params(1) = "abc"
Params(2) = "bcd"
Params(3) = "def"
cmdAddProperty.Execute , Params




here you go....
happy programming...

[forkirun]

try this article too to get a clear idea
http://www.vbworld.com/databases/sql...l4/index6.html