Generating the Graphs in Asp.net

In desing page

// put one literal 

<asp:Literal ID="TATLiteral1" runat="server"></asp:Literal>

In Code Behind

        string sql = "", sql1 = "", sql2 = "", sql3="";

        string condition = "";

        string strXML, strCategories1 ;

        DataTable fdt = null;

        DataTable fdt1 = null;

        DataTable fdt3 = null;

        OracleCommand cmd = null;

        OracleDataAdapter da = null;

       /// genarate the data for your graph

            sql = " Your Query to get data";

            fdt1 = new DataTable();

            cmd = new OracleCommand(sql, conn);

            da = new OracleDataAdapter(cmd);

            da.Fill(fdt1);

     // after getting data put it in the XML format as below

  //  header tag for graph

   

         strXML1 = "<graph  rotateNames='0' animation='1'  numdivlines='4'  baseFont='Arial' baseFontSize='10' baseFontColor='000000' useRoundEdges='1' showLegend='0' bgColor='ffffff' borderColor='ffffff' showYAxisValues='0'>";

   // categories

  strCategories1 = "<categories> <category name='0-2 Hrs' /> <category name='>2 Hrs' /></categories>";

                strXML1 += strCategories1;

// dataset you are providing

                strXML1 += " <dataset seriesName='"+fdt3.Rows[0]["HOSPNAME"]+"' color='8B0000'   showValues='1'>";

                strXML1 += "<set   value='" + fdt1.Rows[0]["Total"].ToString() + "' />";

                strXML1 += "<set   value='" + fdt1.Rows[1]["Total"].ToString() + "' />";

                strXML1 += " </dataset>";

                strXML1 += " <dataset seriesName='"+fdt3.Rows[1]["HOSPNAME"]+"' color='2F4F4F' showValues='1'>";

                strXML1 += "<set   value='" + fdt1.Rows[2]["Total"].ToString() + "' />";

                strXML1 += "<set   value='" + fdt1.Rows[3]["Total"].ToString() + "' />";

                strXML1 += " </dataset>";

                strXML1 += " <dataset seriesName='" + fdt3.Rows[2]["HOSPNAME"] + "' color='20B2AA' showValues='1'>";

                strXML1 += "<set  value='" + fdt1.Rows[4]["Total"].ToString() + "' />";

                strXML1 += "<set  value='" + fdt1.Rows[5]["Total"].ToString() + "' />";

                strXML1 += " </dataset>";

               

                strXML1 += "</graph>";

// binding to literal 

                TATLiteral1.Text = FusionCharts.RenderChartHTML("../ChartsLicense/MSColumn2D.swf", "", strXML1, "Preauthinfo", "350", "170", false);

NOTE : Graph is also depends on the swf files which we provide  like BAR, COLUMN , LINE , STACKED (here m using Multi series column graph)  So download all the swf files from  fusioncharts.com ( refer it for more info for graphs)