HighCharts Dynamic chart implementation with Live data coming from SQL Server DB

Hello,

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

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

Ex:

'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.

METHOD 2:

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

AJAX ASP Programación en C# JavaScript

Nº del proyecto: #4789586

Sobre el proyecto