Update a data to a bounded datagrid view

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.
 
W

William \(Bill\) Vaughn

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.
__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top