[RESOLVED] VS 2013 - Updating TableAdapterManager Raises An Error

[WestFiasco]

Hello, Good Day

I'm hoping someone here can help me with this, I'm using data sources and for awhile now I've been looking into why i can't update the database with new data and this is as far as I've gotten.

When i click save on the auto-generated binding navigator this code runs,

       Me.Validate()
        Me.Table1BindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.NorthwindDataSet)

and on the last line instead of getting a successful update, i get this.


An unhandled exception of type 'System.InvalidOperationException' occurred in UpdateSingleTableWalkthrough.exe

Additional information: Update requires a valid UpdateCommand when passed DataRow collection with modified rows.


After a lot of online searching, i found my way to editing the dataset in the designer. There i noticed the updatecommand is missing

so i attempted to add one and this is where i'm stumped.

I've tried various things that i hoped would work but they've all ended in the database not being updated. I really would appreciate it if anyone here could grant me the use of their knowledge.

Oh and i'm using the Microsoft Access Database Engine as my provider, if that helps.