showing data from database

Question

I want to show last 1 hour data from the database on the graph. I am not getting any idea, please help, how should i do this? Regards

Jaganathan Bantheswaran · Answer

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 { 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

csharp beginner · Answer

Hi Jaganathan, I am sorry, i replied late.. some problems with my computer. But, your codes were really helpful to me. I did not applied them directly, but got idea that how should i do it. Thanks a lot..

csharp beginner · Answer

hello Jignesh, Sorry i replied late. Yes, i am developing a web application. Your suggestion was helpful to me. Thank you

Jignesh Trivedi · Answer

hi, Are you develop web application on window base application.. both have chart control with the help of chart control you can show the record... generally this chart control takes datatable or any other collection as a datasource. so get the data using either command or data adapter and fill data set, assign to control hope this will help you.

showing data from database

Answers (4)