数据库通知到C#WinForms客户端应用程序 [英] Database notifications to C# WinForms Client App

问题描述

我之前曾多次问过这个问题，但是以几种不同的方式，但是我又回来了……我有一个数据库，它每隔几毫秒进行一次实时更新，并且我有一个C#客户端应用程序使用计时器每毫秒轮询一次此表以捕获这些更改，但这非常低效，并且每个人都指出，由于轮询时间可能大于计时器触发时间，因此这种轮询是高效且有问题的. br/>
我正在使用MySql数据库，但似乎无法弄清如何创建事件/通知，该事件/通知在MySql表中发生更新，插入等事件时触发，我的C#应用​​程序可以通过eventHandler订阅该事件/通知...

有人可以帮我吗?

预先感谢，
-DA

I''ve asked this question several times before but in several different ways but I''m back again...I have a database that''s being updated in real-time every few milliseconds and I have a C# client app that polls this table every millisecond with a Timer to grab these changes but this is VERY inefficient and EVERYONE has pointed out to that such polling is efficient and problematic due to the fact that the polling time could be greater than timer firing time.

I''m using a MySql database and I can''t seem to figure out how to create an event/notification that fires when there is a update, insert, etc in my MySql table that my C# app could subscribe to via an eventHandler...

Can someone please help me out here?

Thanks in advance,
-DA

推荐答案

看看下面的链接. http://msdn.microsoft.com/en-us/library/a52dhwx7 (v = vs.80).aspx [

Have a look at the below link..
http://msdn.microsoft.com/en-us/library/a52dhwx7(v=vs.80).aspx[^]

Thanks

这篇关于数据库通知到C#WinForms客户端应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！