Question Update Access via Visiual Studio 2005

dink007

New member
Joined
Nov 13, 2008
Messages
1
Programming Experience
1-3
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.

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?
 

Latest posts

Back
Top