How can I detect when rows are added to a MySQL database?
<p>I have a c# application that picks up files from an ftp server, gets the text out of the file and inserts it into a mysql database.  From there it takes the data and ftp's it to another server within our organization.</p>

<p>What I'm looking to do is create a monitoring program that a user can load on their pc that has a grid and is refreshed everytime a new entry is added into the mysql database.</p>

<p>What's the best way to do this?  I was going to place a timer control on the form and have it check every 30 seconds or so, but is there any way to do this in real time so that my app knows exactly when the item is added to the database?  A control kind of like the FileSystemWatcher but for a database table?</p>
