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?
<asp:Parameter 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):

<asp:Parameter Name="CreditLimit" Type="Decimal" />

ByVal CreditLimit As Decimal

"jobs" <jo**@webdos.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...

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

what type should I use in my sqldatasource parameter in asp.net?
<asp:Parameter 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..?

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

jobs wrote:

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

The type numeric is a synonym for decimal.

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

Decimal

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

Decimal

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

SqlDbType.Decimal

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..?

--
Göran Andersson
_____
http://www.guffa.com