I need to add, setting the textbox value to "" or nothing in code does not
affect the
HasChanges property of the underlying dataset. So, for example,
dsOrg1.HasChanges is false.
Setting the value directly in the dataset does not work since an interger
can't accept DBNull.Value as a value.
Yet, when you initially load the dataset, that column can be null if the
underlying database field is Null.
wr
"WhiskyRomeo" wrote:
I have a bound textbox (bindings are set at design time) to a dataset
column. Sometimes the value of this textbox must be set so that the
underlying database field gets updated to null when using the update method
of the dataadapter.
Since the dataset field datatype is INT32 it gets set to the empty string
equivalent which is 0. Zero is not a valid value so the update fails.
Can this be done without changing the SQL of the udpdate mathed?