How To create an "event" in MySQL

Question

0.00/5 (No votes)

See more:

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

Posted 19-Nov-10 10:30am

d.allen101

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Answer 1 · 2010-11-19T12:54:00

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.

d.allen101 · Answer 2 · 2010-11-19T16:48:00

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.

How To create an "event" in MySQL

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0