Hi Randy,

Make sure the second parameter of LoadDataRow is set to True. This makes sure your changes are accepted. I assume you are also calling BeginLoadData and EndLoadData.

>Hello everybody, I am trying to use the LoadDataRow Method. I have an itemarray that I am checking against a table. If the row exists I want to revert the changes, if the row does not exist I would like to add it to the table. I figured LoadDataRow would be a quick way to do this, but I am having a problem. I am getting the error AccountNumber 411 already exists. AccountNumber is constrained to be unique. I don't understand this because AccountNumber is the primary key, if 411 already exists, shouldn't the row be updated and not added to the table. Thanks for the help.