Data type issue in vb.net wrt sql server 2000

microsoft.public.sqlserver.programming

1 Jul 2005 5:09 PM

Rajesh

I had created a user defined data type in sql server 2000 as follows

Length Prec Scale
AMTTYPE 9 15 2

Can any one help me

what is the equivalent data type in vb.net

I know the double and float its not have the same Prec and Scale .
Therefore I need to format the value with precsion and scale

How to do that ..

Thanks
Rajesh.

1 Jul 2005 5:57 PM

David Gugick

Rajesh wrote:
Show quote

> I had created a user defined data type in sql server 2000 as follows
>
> Length Prec Scale
> AMTTYPE 9 15 2
>
> Can any one help me
>
> what is the equivalent data type in vb.net
>
> I know the double and float its not have the same Prec and Scale .
> Therefore I need to format the value with precsion and scale
>
> How to do that ..
>
> Thanks
> Rajesh.

You should try and use the System.Data.SqlTypes Namespace instead of the
standard VB.Net data types when dealing with SQL Server data. Try using
SqlDecimal.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com