Saving from dataset to the database
Hey im sort what new to vb and i have this problem saving from dataset to the database.
When i run the program and input my data in the text boxes, it saves it but i check in the database the record is not there, plus when i re run the program it has disappeared from the dataset.
I have followed example from msdn and my code is as follows
Code:
Try
Me.Validate()
Me.CustomerBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.LibraryDatabaseDataSet)
Me.CustomerTableAdapter.Update(Me.LibraryDatabaseDataSet.Customer)
MsgBox("Update Successful")
Catch ex As Exception
MsgBox("Update failed")
End Try
what im i missing????? help me please. or any advice please......
novice guy!!!!
Re: Saving from dataset to the database
do you have any insert query in your table adapters?
Re: Saving from dataset to the database
In my sig is a link "I swear I saved my data, where'd it run off to?" Might want to check it out and see if it's applicable.
-tg