<%=GetFactorySummaryChartHtml()%> 



public string GetFactorySummaryChartHtml()

{

   //In this example, we show how to connect FusionCharts to a database.

   //For the sake of ease, we've used an Access database which is present in

   //../DB/FactoryDB.mdb. It just contains two tables, which are linked to each

   //other.



   //xmlData will be used to store the entire XML document generated

   string xmlData;



   //Generate the chart element

   xmlData = "";



   //Iterate through each factory

   string factoryQuery = "select * from Factory_Master";

   using (OdbcConnection connection = DbHelper.Connection(DbHelper.ConnectionStringFactory))

   {

      using (OdbcCommand factoryCommand = new OdbcCommand(factoryQuery, connection))

      {

         using (OdbcDataAdapter adapter = new OdbcDataAdapter(factoryCommand))

         {

            DataTable table = new DataTable();

            adapter.Fill ( table );



            foreach ( DataRow row in table.Rows)

            {

               string quantityQuery = "select sum(Quantity) as TotOutput from Factory_Output where FactoryId=" + row["FactoryId"].ToString();

               using (OdbcCommand quantityCommand = new OdbcCommand(quantityQuery,connection))

               {

                  xmlData += "";

               }

            }

         }

      }

   connection.Close();



   xmlData += "";

   }



   //Create the chart - Pie 3D Chart with data from xmlData

   return FusionCharts.RenderChart("../../FusionCharts/Pie3D.swf", "", xmlData, "FactorySum", "600", "300", false, false);

}