decimal precision

[silenius]

I got a problem

when i transfer data form the dataset to the database, the decimal value are
truncated and not rounded.
Is there a way to round them automaticly. if not, how can i retrieve the
precision of the decimal in the database in dot.net to do the rounding
before?

thanks

 

[Val Mazur]

Hi,

This is a text from MSDN documentation

".NET Framework data providers that ship with .NET Framework version 1.0 do
not verify the Precision or Scale of Decimal parameter values. This can
result in truncated data being inserted at the data source.
If you are using .NET Framework version 1.0, validate the Precision and
Scale of Decimal values before setting the parameter value. When using .NET
Framework version 1.1 or later, an exception is thrown if
a Decimal parameter value is set with an invalid Precision. Scale values
that exceed the Decimal parameter scale are still truncated."

So, when you create Command, which updates database from the dataset, you
could specify precision of the parameter, using Precision and Scale
properties of it.

 

[silenius]

thanks

but is there anyway to do using sqlcommandbuilder?

 

[Val Mazur]

Hi,

When you use CommandBuilder it should do it automatically. If it does not do
it, then you could try to access specific command (Insert/Update/Delete) and
try to modify parameter there