int to numeric numeric(18,2) ?

[jobs]

I have a column that is numeric(18,2) in sql server.

what type should I use in my sqldatasource parameter in asp.net?
<asparameter Name="CreditLimit" Type="Int32" />


what type should I use in my vb.net method that updates this?
ByVal CreditLimit As Integer

What type should I use in my
parameters.Add("@CreditLimit", SqlDbType.Int).Value = CreditLimit

The list combinations do not work as on the way to to the database I
can't send 50.00, but if I enter 50 I do get 50.00 back.

Clearly something I've overlooked, I dont see type numeric or money..?

 

[Brandon Gano]

Have you tried using the Decimal type in your code? For example (not
tested):

<asparameter Name="CreditLimit" Type="Decimal" />

ByVal CreditLimit As Decimal

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

I have a column that is numeric(18,2) in sql server.

The type numeric is a synonym for decimal.