This one is causing me some problems. I am calling LoadDataRow(arPrimaryKey, False) and immediately, the DataRowState of the returned row is DataRowState.Modified. This is a problem because I don't want the DataAdapter to fire off an Update unnecessarily on a row when it doesn't need to do so.

Any help would be greatly appreciated.

***
By the way, my current workaround is to search for the DataRow by using DataTable.Find and if that returns nothing to Add the row. This seems to work but is less elegant.