In Progress

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

Skills: AJAX, ASP, C# Programming, Javascript

See more: highcharts dynamic, highcharts data sql server, highcharts live, highcharts update data, highcharts dynamic update, highcharts insert database, highcharts dynamic real data, use sql database highcharts, highcharts live demo, highcharts json live, highcharts axis dynamic data asp, highcharts dynamic data, highcharts dynamic ajax, dynamic chart implement, highcharts data, highcharts live data, aspx highcharts, highcharts data defined, highcharts aspx, using data database highcharts sql, asp page chart, asp net highcharts live data, highcharts data server, sql highcharts, using highcharts live random data sql

About the Employer:
( 13 reviews ) Tucson, United States

Project ID: #4789586

Awarded to:

codeindiadigital

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.

$50 USD in 2 days
(10 Reviews)
4.1

2 freelancers are bidding on average $40 for this job

Rajan1987Singh

Hi, I can do it for you in short time but the page link will be on php platform .

$30 USD in 1 day
(0 Reviews)
0.0