Hi,
I''m a novice C# developer/MySQL admin and I''m trying to figure out how do I have a MySQL table send table updates or inserts to a C# client app whenever the table is updated or a new record is inserted.
As of now I''ve been using a really crude way of accomplishing this; what I''ve been doing is using a timer in the C# client app to query the MySQL table every second and check for an update and if an update occurred then I pull this data from the table into the C# client for visual display.
Can someone please point me in the right direct as to the correct way of doing this.
Thanks,
-Donald
解决方案Take a look at the MSDN Docs for the BindingSource[^] Component. Particularly the Remarks section.
Does this sound like what you want?
If so, then (theoretically, at least. I''ve never used it with MySql.) all you have to do is set the DataSource property of the BindingSource to whatever is your current data source, then set the DataSource for your controls to the BindingSource.
Thanks for the response Henry Minute but that''s not what I''m looking for. I don''t want to bind the control to the table. I need to analyze the database table data each time the table is updated and if it meets a certain criteria then I''ll display it in via the control.
I want the database table to send the updated record(s) to an object that analyzes the record(s) and determines if it should displayed.