Re: DataAdapter.Update Command Failed To Update Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 10:53:23 -0700

And... (on top of the other good advice) make sure to add Try/Catch
exception handlers to deal with the stuff that happens. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Chris Lee" <tllee@bloomberg.net> wrote in message
news:a48b54be.0408032238.65543345@posting.google.com...
> Thanks for the advice. I have removed the dataset AcceptChanges
> command just prior to the dataadapter Update command. Now, I am
> getting an error when executing the Update command:
>
> Unhandled exception of type System.InvalidOperation.Exception occurred
> in system.dll. Additional information: Dynamic SQL generation for
> UpdateCommand is not supported against a SelectCommand that does not
> return any key column information.
>
> Does that mean that the error occurred because I did not identify the
> PrimaryKey? I left out the PrimaryKey because none of the columns in
> the datatable are unique.