HighCharts Dynamic chart implementation with Live data coming from SQL Server DB
This project was successfully completed by codeindiadigital for $50 USD in 2 days.Get free quotes for a project like this
Project Budget$10 - $30 USD
Completed In2 days
Software to be used: Visual Studio 2010, HighCharts Interactive JS library ([url removed, login to view]). Make sure to copy [url removed, login to view] file locally to your ASPX Website project
I want the below exact implementation as shown in this URL below under method 1
[url removed, login to view] The only difference is that data in this demo is generated randomly whereas I want the data coming from a Real Time live table in SQL Server database.
I have the following SQL table on my side PLCTagData (TagName, TagTimeStamp, TagValue). Every 1 minute I get the new data in the table
'WaterPressure','2013-08-02 19:00:[url removed, login to view]' , 45
'WaterPressure','2013-08-02 19:01:[url removed, login to view]' , 90
TagValue is in the range of 0 to 100.
I have this below script which you can run in a SQL Server Agent and get the table updated every one minute for your TESTING
INSERT into PLCTagData SELECT 'MtoHeadGate',GETDATE(),30 + (100-30)*RAND()
In the Charts X-Axis value is TagTimeStamp and Y-Axis is TagValue.
There is one more example of implementing the Live chart . In this URL([url removed, login to view]) it is defined wherein it uses AJAX. The chart rendering page calls a ASPX page which gives the data in JSON format. The example shown in this URL also has random data but with no DATETIME on X-axis
It would be best to implement using First method described. If not successful then you can use the second method using AJAX. I am open to suggestion and ideas on which would be the best method.
The project in Visual Studio has to be a [url removed, login to view] website project. Make sure that chart renders in all browsers
Deliverables expected. [url removed, login to view] website ZIP file containing the required files and actuall ASPX page showing the Live chart
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online