value watcher question

patrick

I have a box that displays a certain value from a database, and updates that value on a timer. This has seen very inconsistant performance. The database is mysql. What I am wondering is how I can make the program update the value in the box automatically, without using a timer. I would rather not use threading either. Is there a way to detect if the database table has been changed, then update it?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
If you know of an event that will do that, then go for it. The problem is that I can't find anything anywhere in the documentation that specifies that an event is fired when the data is changed from another application. There are many in many classes that might work but I can't find anything in the documentation that specifies that the event happens when the data is changed by another application.
0
patrick16y ago
The easiest thing i could think of is set a variable to always equal the number of rows, then trigger an action if the number of rows changes. is this possible?
0
Sam Hobbs16y ago
Thank you for the clarification. I am also interested in the answer to this. I am trying to find answers. Note that the clarifiaction you provided is the type of information that should be provided in the question initially. I am saying that to help you in the future. I will sure let you know when I find something that helps but I hope someone does.
0
patrick16y ago
I'm using the mysql oledbc connector, the program uses singleton connection. The box isn't bound, it is a list box that displays caller ID data. The data is pulled from the database, filtered by which line the call took place on, then displayed. I am not using table adapters - this is only because I knew how to manually get and filter the data by code already, whereas I would have to learn how to use table adapters.
I appreciate the help and will post anything more to help you help me. Thank you.
0
Sam Hobbs16y ago
Is the box bound to the database?

MySQL has classes for use with .Net. Are you using them or are you using COM objects or some other unmanaged calls?

Are you using TableAdapters?

It is difficult to know what type of info you should post since there is so little to go on. Can you please try to be more specific?
0
patrick16y ago
sorry, what type of info should I post?
0
Sam Hobbs16y ago
There are many ways to use MySQL and you don't specify which you are using.
0