Update a data to a bounded datagrid view

  • Thread starter Thread starter sweetpotatop
  • Start date Start date
S

sweetpotatop

Hi,

I have a datagridview which bounded to a datatable. When I tried the
to update the grid:
adapter.update(table)

I got the following error:
"Update requires a valid InsertCommand when passed DataRow collection
with new rows"

Is it supposed to grab all the info from the grid without explicitly
coding a new row? What is missing from code. Please help.

Thanks in advance. Your advice would be greatly appreciated.
 
This exception means that you or the CommandBuilder has not created the
needed action commands. These Commands (UpdateCommand, InsertCommand,
DeleteCommand) tell the DataAdapter what to do when it comes time to add,
change or delete rows. See my article on the CommandBuilder on my web site
or read one of the books on ADO.NET--all of them cover this.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
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.
__________________________________
 
Back
Top