Realtime updates in asp.net using sqldependency not working

See more:

ASP.NET

Hi all ,

I am trying to update my list view when anything changes in the database in real time.Which means i need to get notified automatically on any change in my database and then the listview data changes on the page without refreshing.So i enabled broker for the northwind database and wrote this code :

protected void Page_Load(object sender, EventArgs e)
 {
GetNames();

}

private void GetNames()
       {
           lbNames.Items.Clear();
           SqlDependency.Stop(connect);
           SqlDependency.Start(connect);
           using (SqlConnection cn = new SqlConnection(connect))
           {
               using (SqlCommand cmd = cn.CreateCommand())
               {
                   cmd.CommandType = CommandType.Text;
                   cmd.CommandText = "SELECT FirstName, LastName FROM dbo.[Employees]";

                   cmd.Notification = null;
                   dep.OnChange += new OnChangeEventHandler(dep_onchange);

                   cn.Open();

                   using (SqlDataReader dr = cmd.ExecuteReader())
                   {
                       while (dr.Read())
                       {
                           lbNames.Items.Add(dr.GetString(0) + " " + dr.GetString(1));
                       }
                   }
               }
           }
       }

public void dep_onchange(object sender, SqlNotificationEventArgs e)
{
    GetNames();
    SqlDependency dep = sender as SqlDependency;
    dep.OnChange -= new OnChangeEventHandler(dep_onchange);
}

but nothing is changed. So any ideas ?