SqlDependency提供了:對(duì)監(jiān)測(cè)的數(shù)據(jù)庫(kù)發(fā)生變化通知前臺(tái)程序的功能。

具體使用如下：

        public Form1()
        {
            InitializeComponent();
            SqlDependency.Start(conStr);
            NewMethod();
        }

        string conStr = "data source=.;initial catalog=AssetsManageDB;uid=sa;pwd=****";
        private void NewMethod()
        {
            using (SqlConnection con = new SqlConnection(conStr))
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("select * from TT where flag=1",con);
                SqlDependency dependy = new SqlDependency(cmd);
                dependy.OnChange += new OnChangeEventHandler(dependy_OnChange);
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    MessageBox.Show(dr["message"].ToString());
                }
                dr.Close();
            }
        }

        void dependy_OnChange(object sender, SqlNotificationEventArgs e)
        {
            NewMethod();
        }

 Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=123;User ID=Admin;Data Source=123.mdb