Data Import From Sql

[NLynch7137]

My company has a metric portal to measure automated tests that populate an SQL database once the tests are run. My question is, is there anyway to have the data for the graphs pulled from the database without just typing the numbers into the parameters of the chart. I'm familiar with pulling elements out of a database to generate a list on the website, but I can't seem to figure out how to get the data from the database associated with the values needed for the chart.

[Guest Sashibhusan]

Hi,

 

Thank you for the post.

 

Yes, FusionCharts works with ASP, ASP.NET, PHP, JSP, ColdFusion, Ruby on Rails, JavaScript or even simple HTML pages and connects to any database (MS SQL, MySQL, Oracle, and PostgreSQL) and pull data for the graphs to plot the latest updated data from database.

 

If I will consider PHP as a server-side technology for your application, for more information on "Plotting data from a database", please follow the link below:

http://docs.fusioncharts.com/charts/contents/?guide-for-web-developers/php/PHP_DB.html

 

If you don't want to make the XML string in PHP manually, FusionCharts provides you the PHP Class, using which you just call the predefined method to retrieve data from the database, form the XML string automatically and plot the graph.

 

For more information on "Using FusionCharts PHP Class > Plotting data from a database", please follow the link below:

http://docs.fusioncharts.com/charts/contents/?guide-for-web-developers/php-class/PHPClass_DB.html

 

Hope this helps!

[Stainless2000]

But this is the ASP.Net forum....do you have a tool for asp?

[Guest Sumedh]

But this is the ASP.Net forum....do you have a tool for asp?

 

Hi,

 

You can plot chart from the database using ASP.

 

You would need to follow these steps -

 

> Connect to the database which has been already created (database file).

> Create database objects - initialization.

> Create record-set to retrieve data

> Generate the chart element and iterate through the database file.

 

For more information, refer the following link:

http://docs.fusionch...asp/ASP_DB.html

 

You can also get the sample from Download package>>Code>>ASP>>DBExample folder.

 

Hope this helps.