Completed

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

This project was successfully completed by codeindiadigital for $50 USD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$10 - $30 USD
Completed In
2 days
Total Bids
2
Project Description

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:[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.

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 [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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online