ADO Parameters

Hi Guys,

I just wanted to know how do i pass multiple paramaters to my stored procedure using Microsoft Active X Object 2.8 Automation? Please need it asap…thank you

Use ‘Microsoft ActiveX Data Objects 2.8 Library’.Parameter and the CreateParameter function of ‘Microsoft ActiveX Data Objects 2.8 Library’.Command

can you show samples…?

See this post:

I am able to add 1 parameter to my program my problem is how will i insert another paramater? does it need to have 2 dimensions or what?

Call the CreateParameter and Append commands for each parameter you wish to add. CreateParameter defines the parameter and Append adds it to the parameter string that is passed to the ADO execute command.