HELO

in order to insert and Update i am using tableAdapte and Dataset, in first look it seems to be working, i do see the insert data in one of my bound controls (listbox) however when i close the app and run it again I DO NOT SEE ANY NEW DATA IN THE TABLE.
i read http://msdn2.microsoft.com/en-us/lib...89(VS.80).aspx
and set the db and dataset Copy to Output Directory to Copy if newer but it still not working.

this is my code:

INSERT AND UPDATE Code:
  1. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

  2.         Me.Validate()

  3.         Me.CategoryCompanyBindingSource.EndEdit()

  4.         Me.CategoryCompanyTableAdapter.Insert(CategoryCompanyNameTextEdit.Text)

  5.         Me.CategoryCompanyTableAdapter.Fill(Me.DatabasecrmDataSet.CategoryCompany)

  6.     End Sub

  7.  
  8.     Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

  9.         Me.Validate()

  10.         Me.CategoryCompanyBindingSource.EndEdit()

  11.         Me.CategoryCompanyTableAdapter.Update(CategoryCompanyNameTextEdit.Text, ListBox1.SelectedValue)

  12.         Me.CategoryCompanyTableAdapter.Fill(Me.DatabasecrmDataSet.CategoryCompany)

  13.     End Sub


TNX