wpf 轮询mysql数据库_WPF非轮询方式实时更新数据库变化SqlDependency

public partial class Page1 : Page

{

private static string connStr;

SqlDataReader sdr;

public Page1()

{

InitializeComponent();

connStr = 数据库连接字符串

SqlDependency.Start(connStr);//传入连接字符串,启动基于数据库的监听

UpdateUI();

}

private void UpdateUI()

{

using (SqlConnection connection = new SqlConnection(connStr))

{

//依赖是基于某一张表的,而且查询语句只能是简单查询语句,不能带top或*,同时必须指定所有者,即类似[dbo].[]

//获取要监控的数据内容，这里只监控一条数据

using (SqlCommand command = new SqlCommand("select ID,UserID,[Message] From [dbo].[Messages] where ID=2", connection))

{

command.CommandType = CommandType.Text;

connection.Open();

SqlDependency dependency = new SqlDependency(command);

//当后台数据库发生变化时，触发该事件

dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);

sdr = command.ExecuteReader();

while (sdr.Read())

{

//线程安全，使用Dispatch线程更新界面

DispatchUpdateUI(sdr);

}

sdr.Close();

}

}

}

private void DispatchUpdateUI(SqlDataReader sdr)

{

try

{

tbxUserID.Dispatcher.Invoke(new UpdatetbxUserDelegate(UpdatetbxUserIDAction));

tbxMessage.Dispatcher.Invoke(new UpdatetbxMessageDelegate(UpdatetbxMessageAction));

}

catch (Exception ex)

{

throw ex;

}

}

private delegate void UpdatetbxUserDelegate();

private delegate void UpdatetbxMessageDelegate();

private void UpdatetbxUserIDAction()

{

tbxUserID.Text = sdr["UserID"].ToString();

}

private void UpdatetbxMessageAction()

{

tbxMessage.Text = sdr["Message"].ToString();

}

private void dependency_OnChange(object sender, SqlNotificationEventArgs e)

{

UpdateUI();

}

}