updating main data source

[Grant]

For some reason I cannot update certain adapters using the command:
'predecessorAdapter.Update(agencyDatabaseDataset1) '.

The error message I get is:

Operation must use an updateable query.
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)
at AgencyDatabaseAdminTool.MainForm.menuItem4_Click(O bject sender,
EventArgs e)

Does this have anything to do with the insert or update statement?

Update statement looks like:
UPDATE Predecessor
SET comments = ?, predecessor = ?, successor = ?
WHERE (predecessor = ?) AND (successor = ?)

Insert statement look like:
INSERT INTO Predecessor
(comments, predecessor, successor)
VALUES (?, ?, ?)
Thanks,
Grant

[William Ryan eMVP]

Hi Grant:

The first thing to look at is verify that you have a primary key . This is
the most common cause of this particular error that I've seen.

--
W.G. Ryan MVP Windows - Embedded

www.devbuzz.com
www.knowdotnet.com
http://www.msmvps.com/williamryan/
"Grant" <gp*****@hotmail.com> wrote in message
news:eN****************@TK2MSFTNGP12.phx.gbl...

For some reason I cannot update certain adapters using the command:
'predecessorAdapter.Update(agencyDatabaseDataset1) '.

The error message I get is:

Operation must use an updateable query.
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)
at AgencyDatabaseAdminTool.MainForm.menuItem4_Click(O bject sender,
EventArgs e)

Does this have anything to do with the insert or update statement?

Update statement looks like:
UPDATE Predecessor
SET comments = ?, predecessor = ?, successor = ?
WHERE (predecessor = ?) AND (successor = ?)

Insert statement look like:
INSERT INTO Predecessor
(comments, predecessor, successor)
VALUES (?, ?, ?)
Thanks,
Grant