I am building COM add-ins to POS with VB.NET I'd like tu use QSRules.Session.Database to run stored procedure But I don't know how. Procedure has one input parameter and the other is output parameter. Can anyone know how I should do that?
Thanks, Ene
You're not going to be able use the output parameter using the functions in QSRules. You need a command object to set the parameters and retrieve the output value after running the command. QSRules will let you run a sp that returns a recordset, but nothing that lets you work with a command as far as I know.
You can steal the connection string from QSRules by running a simple query then checking the ActiveConnection property of the returned recordset. Of curse, that connectionstring only works in ADO - if you want to use the .Net SQL Connection objects, you'll have to parse and reformat the connection string...
Glenn Adams Tiber Creek C> I am building COM add-ins to POS with VB.NET
What is the connection string for ADO and for .NET connection object? Having problems with these - using Visual Studio 2005 express edition.
Thanks Danny
"Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP02.phx.gbl...
Have something to add? Share your thoughts — no account required.
Ask the community — no account required