SqlParameter overloads

[Mike P]

I'm executing a stored procedure and trying to return a decimal data
type with 4 decimal places. To do this requires this overload of
SqlParameter :

SqlParameter prmCash = new SqlParameter("@Cash", SqlDbType.Decimal, 9,
ParameterDirection.Output, false,
19, 4, "CASH", DataRowVersion.Current, null);

I'm not too sure whether the last 2 parameters (DataRowVersion and
value) are what I should be using. Can anybody advise me on this?
Cheers,

Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Andrew J. Kelly]

Does it work? I am pretty sure those are correct for what you want but the
true test is always simply testing it<g>.

--
Andrew J. Kelly SQL MVP
"Mike P" <mr*@telcoelectronics.co.uk> wrote in message
news:uB**************@TK2MSFTNGP15.phx.gbl...

I'm executing a stored procedure and trying to return a decimal data
type with 4 decimal places. To do this requires this overload of
SqlParameter :

SqlParameter prmCash = new SqlParameter("@Cash", SqlDbType.Decimal, 9,
ParameterDirection.Output, false,
19, 4, "CASH", DataRowVersion.Current, null);

I'm not too sure whether the last 2 parameters (DataRowVersion and
value) are what I should be using. Can anybody advise me on this?
Cheers,

Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!