int to numeric numeric(18,2) ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jobs - 21 Jul 2007 18:11 GMT

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

Reply to this Message

Brandon Gano - 21 Jul 2007 22:28 GMT

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

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

ByVal CreditLimit As Decimal

>I have a column that is numeric(18,2) in sql server.
>
[quoted text clipped - 11 lines]
>
> Clearly something I've overlooked, I dont see type numeric or money..?

Reply to this Message

Göran Andersson - 22 Jul 2007 01:32 GMT

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

Signature

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

Reply to this Message

Rate this thread:

int to numeric numeric(18,2) ?

Free Magazines