showing data from database

Hi,

You can achieve this using Timer.

var timer = new System.Timers.Timer(1000);
int lastHour = DateTime.Now.Hour;
timer.Elapsed += new ElapsedEventHandler(OnTimedEvent);
private static void OnTimedEvent(object source, ElapsedEventArgs e)
{
if(lastHour < DateTime.Now.Hour || (lastHour == 23 && DateTime.Now.Hour == 0))
{
lastHour = DateTime.Now.Hour;
YourMethodToGetData();
}

}

In SQL,

select the data updated/created within an hour.

SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN timenow-1 AND timenow