Re: SqlParameter overloads

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 11:12:22 -0500

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" <mrp@telcoelectronics.co.uk> wrote in message 
news:uBMR2Iw0EHA.2804@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!