Hi in case your still interested in finding the solution for this.
This is what worked for me.
I needed to refresh the data that the form has, but the microsoft refresh button is not doing the trick, so here is what i did:
I created a sub procedure called "loadReport", which must happen at form load, and on click event of refresh button.
Here is how my code looks like:
Private Sub loadReport()
'TODO: This line of code loads data into the 'myDataSet.Events' table. You can move, or remove it, as needed.
'TODO: This line of code loads data into the 'myDataSet.eventtable' table. You can move, or remove it, as needed.
Catch ex As Exception
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' Call the sub procedure on form load
Private Sub btnRefresh_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRefresh.Click
'Call the sub procedure on refresh button