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
Hello sir, I'm a freelancer from India. I've more than 5yrs excperience in .net. I've gone through the links you provided. I can do it easily with your method 1. Please consider my bid. Thank You.