0

I am creating an application and some of the information relies on data found in an SQL table. On pageload, this is bound to a ListView, but how do I get the list to auto refresh (re-bind) if more data is added to the SQL table?

I have considered calling the bind every 10 seconds or so, but that seems to be a bit old fashioned.

Any tips?

user692942
  • 16,398
  • 7
  • 76
  • 175
Rob Jeffrey
  • 124
  • 12
  • Look into the [SqlDependency](https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx) class. [SO Thread](http://stackoverflow.com/a/5288505/1895201) – DGibbs May 18 '16 at 13:53
  • Possibly early days but it seems that SqlDependacy is what I need for this. I will try it out later and update with my progress. Thanks! :D – Rob Jeffrey May 18 '16 at 13:57

1 Answers1

-1

What you have is called Pulling Data from server. What you want is called pushing data to Client. Try SignalR for pushing data.

Anup Sharma
  • 2,053
  • 20
  • 30