all groups > visual studio .net enterprise tools > march 2005 >
You're in the

visual studio .net enterprise tools

group:

Stored Procedure in/out and return parameters


Stored Procedure in/out and return parameters Gurbhajan S. Bagh
3/12/2005 5:42:19 PM
visual studio .net enterprise tools:
Does anyone know how to use parameters that are both input and output and
return value parameters through the Enterprise Library data application
block?

Many thanks,

Gurbhajan

Re: Stored Procedure in/out and return parameters Gurbhajan S. Bagh
3/17/2005 7:50:35 PM
Although not as simple as AddInParameter or AddOutParameter, I found the
following works.

AddParameter(name, dbType, size, ParameterDirection.ReturnValue, true, 0, 0,
String.Empty, DataRowVersion.Default, DBNull.Value);

I didn't know what value to pass to the sourceVersion parameter.

Gurbhajan.

[quoted text, click to view]

Re: Stored Procedure in/out and return parameters Scott Densmore
3/23/2005 7:15:43 AM
Hello Gurbhajan,

Source Version maps to the SourceVersion property on an IDataParameter -
sets the DataRowVersion to use when loading Value.

scott

[quoted text, click to view]


AddThis Social Bookmark Button