Can updating a dataset with the same value cause a basic update?

Question

Say I have a dataset and I change the value in datarow, but the value is identical to the old value:

dataRow["someField"] = 2; // but it already had value 2!

Does this mean that the update statement must be executed in the database, or does it recognize that nothing has changed and the update has not been performed?

Answer 1

Take a look at the DataRow.RowState property.

If the string was previously unchanged, then setting the value will change the value of RowState to Modified.

You will need to manually verify the equality before setting the row values.

Answer 2

This will result in an update.