[dba-VB] Parameter objects in C# and ADO.

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Thu Nov 26 00:02:40 CST 2009


Hi John,

Yes. Set System.Data.ParameterDirection.Output for .Direction property of
output parameters.

--
Shamil

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, November 26, 2009 5:25 AM
To: VBA
Subject: [dba-VB] Parameter objects in C# and ADO.

If a parameter in a stored procedure is declared as an output (returns a
value) will the parameter 
object in C# / ADO contain that value when the stored procedure finishes?

I haven't used output parameters yet in stored procedures.  Can values be
passed in via an output 
parameter or can it only be set from inside of the stored procedure?

-- 
John W. Colby
www.ColbyConsulting.com
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4637 (20091125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru


 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4637 (20091125) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru
 




More information about the dba-VB mailing list