Hi,
I'm trying to build a database application in Visual Studio 2005 express Edition. Using Visual Basic, and a sample Access database, I created a new Windows Application, added a database, created a table, and then used the Configure Dataset wizard to create a tableset with the new table Table 1.
I dragged the tableset into the form, and Visual Studio 2005 created all the links, adapter, binging and dataset. But the problem is, the Save button in the Binding Navigator control doesn't work. It doesn't give an error, but when I close
the form and open the table to view its data, I can't find the newly entered
data.
I tried it on a windows XP machine and a Vista installed one, same issue.
Any ideas why it is not saving?
Thanks very much.
Shef
Here is the code for the form;
======================================
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'NwindDataSet1.Categories' table. You can move, or remove it, as needed.
Me.CategoriesTableAdapter.Fill(Me.NwindDataSet1.Ca tegories)
End Sub
Private Sub CategoriesBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()
Me.CategoriesBindingSource.EndEdit()
Me.CategoriesTableAdapter.Update(Me.NwindDataSet1. Categories)
End Sub
Private Sub CategoriesBindingNavigatorSaveItem_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
CategoriesBindingNavigatorSaveItem.Click
Me.Validate()
Me.CategoriesBindingSource.EndEdit()
Me.CategoriesTableAdapter.Update(Me.NwindDataSet1. Categories)
End Sub
End Class