Refresh forms after synchronize

[Bill Patten]

I have a sql database program on a Dell Axim using compact framework 2 and
vb. I Synchronize using my IIS and a wireless connection and the
synchronizing is successful. However the only way I can see the changes on
the forms is to close the program and re open.

I have tried testing for open forms and my last test was as follows. Can
some one point me in the right direction so that I can just push a refresh
button or even better call the routine after resync is complete so I don't
have to close and reopen the program..

Dim sMsg As String = ""
Cursor.Current = Cursors.WaitCursor
BPPIMDataSQLDataSet.Reset()
' Loop through open forms
If My.Forms.Main.Visible = True Then
'Reset Data

My.Forms.Main.CalendarTableAdapter.ClearBeforeFill = True
My.Forms.Main.CalendarTableAdapter.Fill(Me.BPPIMDataSQLDataSet.Calendar)
'My.Forms.Main.CalendarBindingSource.ResetBindings(True)
sMsg = sMsg + "Updated Main: "
End If

If My.Forms.Contacts.Visible = True Then .........


I also tried
My.Forms.Main.CalendarTableAdapter.get()

to no avail

Thanks

Bill

 

[davebythesea]

Hi Bill,

Have you tried calling Refresh() or Invalidate() on the form?

Dav

 

[Bill Patten]

Dav,

Thanks for the reply, I had tried refresh but not invalidate, no cigar how
ever. I think the problem has to do the SQL server gets updated but the
dataset does not. I could not find a dataset.refresh or similar thing, and
even if that worked would it update the datatables that the forms are bound
to?

Any other ideas???

Bill

Hi Bill,

Have you tried calling Refresh() or Invalidate() on the form?

Dav