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: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([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 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
The Budget is flexible under 50-60 dollars
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.