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.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi