I am brand new to vb.net and Visual Studio. I am following a series of lessons where I am supposed to be able to connect to a SQL Server Database bind the db to a form and then edit, add and delete records from within the form. When I run the project everything appears to work correctly, I can change the table data, add or delete rows but once I close the project and look at the underlying data, none of the changes are reflected. When I re-run the project, the data is just as it was before I made the changes.
I can edit the data directly in the tables and it works as you would expect. I'm sure that this is something bone-headed that I'm missing but I can't for the life of me find it.
Any guidance
Thanks in advance for your help.
mpj
DB Changes not committed in VS/SQL Server DB
Swanands
Thanks very much for your help. I really did do a search before I posted but I was in the wrong forum when I did it.
Truly appreciated!!
Tom Freedman
Which method are you following to send data to DB
if dataadapter and datasets, then are you using update method
JHMiller - MSFT
Private
Sub CustomerBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CustomerBindingNavigatorSaveItem.Click Me.Validate() Me.CustomerBindingSource.EndEdit() Me.CustomerTableAdapter.Update(Me.MyCompanyDBDataSet.Customer) End SubI think that answers your question.
Thanks,
mpj
nimbusism
i guess answer to your question is already given in this forum check this link http://forums.microsoft.com/msdn/showpost.aspx postid=69953&siteid=1