Create charts from SQL data in a web page
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.
Considering my experience level is "Beginner" in ASP.Net, VB, JavaScript, XML and SQL, how should I best approach this task?
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)
-David
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.
Considering my experience level is "Beginner" in ASP.Net, VB, JavaScript, XML and SQL, how should I best approach this task?
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)
-David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the suggestion. If you have experience with ZedGraph I would really appreciate any code or query examples you could share. I'm not very experienced and examples sure are helpful.
Thank you again for recommending ZedGraph!
Thank you again for recommending ZedGraph!
bind a DataTable to ZedGraphWeb to have it plot the datapoints
http://zedgraph.org/wiki/index.php?title=How_do_I_bind_a_DataTable_to_ZedGraphWeb_to_have_it_plot_the_datapoints%3F
a full example on zedgraph wiki
http://zedgraph.org/wiki/index.php?title=Use_RenderMode.ImageTag_in_a_web_page
(it uses rendermode :
Imagetag which means an IMG tag is generated in place and image is generated and saved in specified folder)
Hope it helped.
http://zedgraph.org/wiki/index.php?title=How_do_I_bind_a_DataTable_to_ZedGraphWeb_to_have_it_plot_the_datapoints%3F
a full example on zedgraph wiki
http://zedgraph.org/wiki/index.php?title=Use_RenderMode.ImageTag_in_a_web_page
(it uses rendermode :
Imagetag which means an IMG tag is generated in place and image is generated and saved in specified folder)
Hope it helped.
ASKER
Terrific! Thank you.
ASKER
I think my next hurdle will be queries to get the calculations into those arrays.