Retrieve data from database

I need to use C# to get data fro开发者_StackOverflowm database(sql) and the data in database is updated every few seconds. So do I have to make a loop or there is a better way to do that? Is it possible that when database is updating, the program can wait until it finishes updating? thx!

Take a look at Query notifications in ADO.Net. These allow your code to be notified by SQL Server whenever the results of a particular query change.