TableAdapter.Update not updating table

[Jay59]

Private Sub TechsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TechsBindingNavigatorSaveItem.Click
Try
Me.Validate()
Me.TechsBindingSource.EndEdit()
Me.TechsTableAdapter.Update(Me.QC_DatabaseDataSet.Techs)
MsgBox("Update successful")

Catch ex As Exception
MsgBox("Update Failed")
End Try

End Sub

I created the datasource and dragged it to a form.

When I hit save, I get the Update successful, but no data is in the database.


I'm sure its something simple, but I'm still learning.

TIA

 

[Arg81]

What database? If it's access, check out the link in my signature....(Embedded Database)

 

[JohnH]

Try also cjards DNU.

 

[Jay59]

Its a .mdf file in the same directory as app.

 

[Jay59]

I want thru this faq

http://vbdotnetforums.com/attachment.php?attachmentid=1108&d=1174038286

But when I run the program I don't get a "dirty" database copied over.

I have the database property set to Copy Always.

 

[JohnH]

If you Copy Always you get the usually empty db from project copied to build folder each time you start the app, which means anything you do during debugging runtime is lost between runs.

 

[cjard]

I have the database property set to Copy Always.

Read the DNU link in my signature. If you get to the end of it and still cant work out why "Copy Always" is the root cause of your table adapter "never saving the data problem" then you probably need to return your computer to the store for a refund and leave the coding to someone else..

 

[Jay59]

Not sure why but I had to start from scratch to make it work.

 

[cjard]

http://www.vbdotnetforums.com/showpost.php?p=77241&postcount=7

 

[Jay59]

Sorry been out of town.


Thanks for the assistance.