I am developing a Windows app that has quite a few controls bound to a dataset. The dataset is created from a single SQL Server 2000 table.
If a textbox is bound to a field who's DataType is 'decimal' in the database table, then I cannot delete the value in the textbox. Changing the value to another decimal value works fine, but deleting the value seems to be interpreted as an empty string and not accepted as a decimal value.
I usually appreciate this automatic validation in databound controls, but now I need to have the ability to remove a decimal value from the database instead of just being able to change it.
How do I get around this??? Thanks.