[RESOLVED] Updating DatagridView Code

[crampz]

Hi all

i have this bit of code for searching for a number from a db and returning it to a datagridview

Dim con5 As New OleDb.OleDbConnection
        Dim ds5 As New DataSet
        Dim da5 As OleDb.OleDbDataAdapter
        Dim SQL5 As String
        con5.ConnectionString = My.Settings.GoodsinConnect
        con5.Open()
        ds5.Clear()
        SQL5 = "SELECT * FROM [ReceiptLines] WHERE [PartNo] ='" & Partnumber & "'"
        da5 = New OleDb.OleDbDataAdapter(SQL5, con5)
        da5.Fill(ds5, "ReceiptLines")
        dgvPartNumbers.DataSource = ds5.Tables(0).DefaultView
        con5.Close()

This works fine.

However when a user updates a record that is shown via another form. When they are returned back to the main form i want the record to be updated.

So for now i put a simple timer in that looks when the record is updated and a value is changed and when it has then it triggers

Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
        If RefreshData = 1 Then
             btnSearch_Click(Me, EventArgs.Empty)
            RefreshData = 0
        End If
    End Sub

I've also tried:

Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
        If RefreshData = 1 Then
             btnSearch.PerformClick()
            RefreshData = 0
        End If
    End Sub

Although it goes through the code like it would it doesnt actually update the datagridview.

However if i press the button on the form it updates it.


Can anyone help me out here.

Thanks
Alex