how to create chart with data from db?

[squizoid]

I am using classic asp to get data from database and loading into an xml string, how do I setup the new fusioncharts? It was working fine, but now we have upgraded to XT for single developer it is all different.
 
I had an include file which does all the calcs from db then adds to strXML as below:

<% 		
		'strXML will be used to store the entire XML document generated
   Dim strXML
 strXML = "<graph xaxisname='' yaxisname='Percent' numberSuffix='%25' basefontsize='12' basefont='Arial' hovercapbg='DEDEBE' decimalPrecision='0' hovercapborder='889E6D' rotateNames='0' animation='1' yAxisMaxValue='100' numdivlines='9' divLineColor='CCCCCC' divLineAlpha='80' decimalPrecision='0' showAlternateHGridColor='1' AlternateHGridAlpha='30' AlternateHGridColor='CCCCCC' caption='Percentage of Engagement' subcaption='' >"
 'Generate <set name='..' value='..'/> 
      strXML = strXML & " <categories font='Arial' fontSize='12' fontColor='000000'> <category name='" & date_1 & "' hoverText=''/> <category name='" & date_2 & "' /> <category name='" & date_3 & "' /> <category name='" & date_4 & "' /> </categories>"
	  strXML = strXML & "<dataset seriesname='Actively Disengaged' color='CD8517' showValues='0' alpha='100'> <set value='" & Cint(disen1*100) & "' /> <set value='" & Cint(disen2*100) & "' /> <set value='" & Cint(disen3*100) & "' /> <set value='" & Cint(disen4*100) & "' /> </dataset>"
	  strXML = strXML & "<dataset seriesname='Not Engaged' color='FEEEBB' showValues='0' alpha='100'> <set value='" & Cint(noten1*100) & "' /> <set value='" & Cint(noten2*100) & "' /> <set value='" & Cint(noten3*100) & "' /> <set value='" & Cint(noten4*100) & "' /> </dataset>"
 	  strXML = strXML & "<dataset seriesname='Engaged' color='F9B240' showValues='0' alpha='100'> <set value='" & Cint(engaged1*100) & "' /> <set value='" & Cint(engaged2*100) & "' /> <set value='" & Cint(engaged3*100) & "' /> <set value='" & Cint(engaged4*100) & "' /> </dataset>"
 'Finally, close <chart> element
   strXML = strXML & "</graph>"
%> 

Then from ASP page load the chart as below:

        <script type="text/javascript">
       var myChart = new FusionCharts("../../../FusionCharts/FCF_StackedColumn2D.swf", "myChartId", 450, 450); 
        myChart.setDataXML("<%=strXML%>"); 
	   myChart.render("chartdiv");
   </script>

Can I still use this method to create a chart using current version??? Can't find much help on how to format new FusionCharts
 

[Moonmi Sonowal]

Hi,

 

Could please have a look at our documentation for asp.net ?

 

Link: http://www.fusioncharts.com/dev/usage-guide/using-with-server-side-languages/asp-net/creating-charts-with-data-from-a-database.html

 

Hope this helps.

 

Thanks.