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()
Try
'TODO: This line of code loads data into the 'myDataSet.Events' table. You can move, or remove it, as needed.
Me.EventsTableAdapter.Fill(Me.myDataSet.Events)
'TODO: This line of code loads data into the 'myDataSet.eventtable' table. You can move, or remove it, as needed.
Me.eventtableTableAdapter.Fill(Me.myDataSet.eventtable)
' Me.EventsTableAdapter.Fill(Me.myDataSet.Events)
Me.ReportViewer1.RefreshReport()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' Call the sub procedure on form load
loadReport()
End Sub
Private Sub btnRefresh_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRefresh.Click
'Call the sub procedure on refresh button
loadReport()
End Sub