ahashash
asked on
how to pop a message for a change in the database?
hi
so im using visual studio 2010, making a winform vb.net...
i have a bindingNavigator, im connecting and using database here but, i connect using visual studio tools, im not fully typing the whole thing, so, basically i used a binding navigator, and the thing is that when a certain calculation appears (through the use of timer or not) the record do get affected and i get the results i want and it will be stored, only thing, is that when this change happens i pop a msgbox, problem is that change happens through all the records i need, but pops a msgbox only for the record that the bindingNavigator is currently on! i was thinking to loop through the datatables or something but dont know how about..
sample:
Private Sub picturebox_VisibleChanged( sender As System.Object, e As System.EventArgs) Handles picturebox.VisibleChanged
If picturebox.Visible = True Then
If MessageBox.Show("FIRE SAFETY, DATE NEAR, SO, A MONTH EXTENSION?", "ALMOST DUE" & vbNewLine, MessageBoxButtons.YesNo) = DialogResult.Yes Then
FIRESAFETYTESTDateTimePick er.Value = FIRESAFETYTESTDateTimePick er.Value.A ddDays(31. 0)
Else
Exit Sub
End If
End If
End Sub
this will take place if i navigate to (it)....through binding navigator....
any tips please?
thanks
so im using visual studio 2010, making a winform vb.net...
i have a bindingNavigator, im connecting and using database here but, i connect using visual studio tools, im not fully typing the whole thing, so, basically i used a binding navigator, and the thing is that when a certain calculation appears (through the use of timer or not) the record do get affected and i get the results i want and it will be stored, only thing, is that when this change happens i pop a msgbox, problem is that change happens through all the records i need, but pops a msgbox only for the record that the bindingNavigator is currently on! i was thinking to loop through the datatables or something but dont know how about..
sample:
Private Sub picturebox_VisibleChanged(
If picturebox.Visible = True Then
If MessageBox.Show("FIRE SAFETY, DATE NEAR, SO, A MONTH EXTENSION?", "ALMOST DUE" & vbNewLine, MessageBoxButtons.YesNo) = DialogResult.Yes Then
FIRESAFETYTESTDateTimePick
Else
Exit Sub
End If
End If
End Sub
this will take place if i navigate to (it)....through binding navigator....
any tips please?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.