I have to create a website that displays SQL Server data in chart form. Bar charts, line charts and some pie charts may be required.
The data is just tables of numbers like the winning lottery numbers by date.
SQL queries will be doing sums, averages and such on the numbers to produce the data for the charts.
The Website is hosted on a "1and1" shared host with Microsoft SQL Server 2005 and ASP.Net 2.0 support.
I'm looking for the easiest way to get the data from the database into charts.
What chart technology would work best for this scenerio?
I've looked at amCharts, FusionCharts 2.0 (because it's free) and the Google Chart API. I need someting easy to go from Query to chart. Seems like XML is the way to go if the charts can read an XML file and I can get the queries to output to XML.
Thanks for suggestions, examples, experiences and code samples (especially SQL to XML examples)