using System;
using System.Collections;
using System.Configuration;
using System.Data;

using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

using InfoSoftGlobal;

public partial class DB_dataURL_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //In this example, we show how to connect FusionCharts to a database 
        //using dataURL method. In our other examples, we've used dataXML method
        //where the XML is generated in the same page as chart. Here, the XML data
        //for the chart would be generated in PieData.aspx.

        //To illustrate how to pass additional data as querystring to dataURL, 
        //we've added an animate	property, which will be passed to PieData.aspx. 
        //PieData.aspx would handle this animate property and then generate the 
        //XML accordingly.

        //For the sake of ease, we've used an Access database which is present in
        //../App_Data/FactoryDB.mdb. It just contains two tables, which are linked to each
        //other.

        //Variable to contain dataURL
        //Set DataURL with animation property to 1
        //NOTE: It's necessary to encode the dataURL if you've added parameters to it
        String dataURL = ("PieData.aspx?animate=1");

        //Create the chart - Pie 3D Chart with dataURL as strDataURL
        Literal1.Text = FusionCharts.RenderChart("../FusionCharts/Pie3D.swf", dataURL.ToString(), "", "FactorySum", "600", "300", false, true, false);
    }
}