Hello everyone.
My problem is I've created a database in Access 2003.
In Visual Studio 2005 I've created a datagrid to show a couple of the columns.
I've created update queries etc.
When the programme runs it loads everything from mdf file not a problem.
All my updates work.
When I close the programme then re run it it doesnt show anything updated, just the original details inside mdf file.
Any suggestions anyone?
My problem is I've created a database in Access 2003.
In Visual Studio 2005 I've created a datagrid to show a couple of the columns.
I've created update queries etc.
When the programme runs it loads everything from mdf file not a problem.
All my updates work.
VB.NET:
Private Sub ButSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButSave.Click
Try
Me.StockTableAdapter.UpdateToStockCar(Me.NumUpDownCarNo.Value, Integer.Parse(Me.StockIDTextBox.Text))
Me.DataGridView1.ClearSelection()
Me.StockTableAdapter.FillByType(Me.StockDS.stock, Me.TypeNameComboBox.Text)
Me.NumUpDownCarNo.Visible = False
Me.ButSave.Visible = False
Me.ButCancel.Visible = False
Me.ButStock.Enabled = True
Me.ButRepair.Enabled = True
Catch ex As Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
End Sub
When I close the programme then re run it it doesnt show anything updated, just the original details inside mdf file.
Any suggestions anyone?