>>-------------
>>Although it did shorten the WHERE clause as I see. But it included all columns in the update, not only the changed values.
>
>Add an event handler for the data adapter's OnRowUpdating event (
http://msdn.microsoft.com/en-us/library/system.data.common.dbdataadapter.onrowupdating%28v=vs.110%29.aspx). Check the command used there and verify whether or not the values in the columns changed. Also make sure the data adapter's UpdateBatchSize is set to 1.
I really hate MSDN documentation! Why not show samples of implementation :( Every single link requires lots of extra googling...
If it's not broken, fix it until it is.
My Blog