<pre name="code" class="csharp"><pre name="code" class="plain">今天做项目,要监测数据库某张表发生变化,在网上找了下方法,发现C#中SqlDependency可以采用非轮训的方式来监测数据库是否发生改动,基本的代码如下:
<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"></span><pre name="code" class="csharp"> void IRegister.register()
{
SqlDependency.Start(connectionString);//传入连接字符串,启动基于数据库的监听
UpdateGrid();
}
private void UpdateGrid()
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
// using (SqlCommand command = new SqlCommand("select id,name,passportNumber,nationality,gender,thumbnailName,featureData,fullImage