You have chosen to sponsor your bid up to a maximum amount of .
Software to be used: Visual Studio 2010, HighCharts Interactive JS library (HighCharts.js). Make sure to copy HighCharts.js file locally to your ASPX Website project
I want the below exact implementation as shown in this URL below under method 1
http://www.highcharts.com/demo/dynamic-update. 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:00.000' , 45
'WaterPressure','2013-08-02 19:01:00.000' , 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(http://docs.highcharts.com/#preprocessing-live-data) 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 ASP.NET website project. Make sure that chart renders in all browsers
Deliverables expected. ASP.NET website ZIP file containing the required files and actuall ASPX page showing the Live chart
Additional Project Description:
08/03/2013 at 6:29 IST
The Budget is flexible under 50-60 dollars