Data Binding to Access Query - Update problem

  • Thread starter Thread starter Diarmuid
  • Start date Start date
D

Diarmuid

From the data sources window, I dragged a query called qryWeeks onto my
form. This created
QryWeeksBindingSource
QryWeeksTableAdapter
QryWeeksBindingNavigator

It displays fine, but the Save on qryWeeksBindingNavigator doesn't work. The
error is
"Update requires a valid UpdateCommand when passed DataRow collection with
modified rows."

The error occurs in the Dataset designer, in this function

Public Overloads Overridable Function Update(ByVal dataTable As
HTPlannerDataSet.qryWeeksDataTable) As Integer
Return Me.Adapter.Update(dataTable)

End Function



I have yet to write any code in this project, so I'm wondering what I should
change to get it working.

Thanks

Diarmuid
 

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

data grid update 10
datagridview update with dataset and dataasapter 1
Update Access data 4
Error on Select method on DataTable 6
Data Binding GUI refresh 2
dt.reset() destroys independent datarow in memory 1
update datarow problem 6
Password encryption and binding 2

Back
Top