numeric data type

[Mike P]

I am using a stored procedure to get a value from a table, but the
parameter I need to pass is a numeric data type in the table. The SQL
Parameter object in .NET seems to support most of the SQL Server data
types, but not numeric. Can anybody tell me what data type I need to
use?
Any help would be really appreciated.
Cheers,

Mike

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

[Chris R. Timmons]

Mike P <mr*@telcoelectronics.co.uk> wrote in
news:e3**************@TK2MSFTNGP15.phx.gbl:

I am using a stored procedure to get a value from a table, but
the parameter I need to pass is a numeric data type in the
table. The SQL Parameter object in .NET seems to support most
of the SQL Server data types, but not numeric. Can anybody tell
me what data type I need to use?

Mike,

In SQL Server, the decimal and numeric types are equivalent. In
..Net, use SqlDbType.Decimal.
--
Hope this helps.

Chris.
-------------
C.R. Timmons Consulting, Inc.
http://www.crtimmonsinc.com/