this is the error message

  • Thread starter Thread starter JH
  • Start date Start date
J

JH

This is the error message I receive every time I run the program.

An unhandled exception of type 'System.InvalidOperationException' occurred
in system.data.dll
Additional information: Update requires a valid InsertCommand when passed
DataRow collection with new rows.


help
 
Your program doesn't know how to update the data, since you didn't specify
any insert command, to tell it how to do the insert.
 
I suggest you read up on the dataadapter class, and updating data. There are
tons of articles online. But the idea is that it can't magically happen all
on its own, you will need to define all the commands. There is a
SqlCommandBuilder class that can help generate them.
 

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

Similar Threads

How to update dataset? 15
Getting a Delete Command to work using Dataset & Data Adapter 2
Need help with this Error 1
ADO Novice 2
Adding a record using C# 1
Problem saving changes to table 3
DB_SEC_E_AUTH_FAILED(0x80040E4D) 0
Update a data to a bounded datagrid view 1

Back
Top