Symptoms

When you try to update the records in a dataset, you might get an error saying "The type of column 'Quantity' is incompatible with the source column type".

Cause

The reason for this behavior is the data types mismatch.

Resolution

Please make sure that the column corresponding to 'Quantity' column in a source database has the Double value for a field type.