Handling Decimal type columns in SQL Server

[dee-u]

This should be more of a GUI issue so I am posting here instead.

Decimal type columns have Precision and Scale where the length of the integral part of the decimal would be Precision - Scale, if the Precision is 4 and the Scale is 2 then the integral part can only contain 2 digits (4-2).
As such I will probably need a control that I could set how much it should accept on its integral part. In that regard I am not sure which control is best for such cases, I could try to make a usercontrol that will handle that but is there any other control out there that I could utilize for this purpose, intrinsic to .Net or a custom control out there?

I could also just validate the data keyed-in but the above solution seem to be more user-friendly.

Curiously, when databinding such Decimal type columns, how is it handled when the specified integral part exceeds the allowable size (Precision minus Scale)?

[dee-u]

None so far?