1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
   | protected void Page_Load(object sender, EventArgs e)
    {
        yaflaSVG2DPie oChart = new yaflaSVG2DPie();
        oChart.SVGTitle = "Statistique de transfert d'article";
 
        MySqlConnection conn = new MySqlConnection("server=localhost;database=gestion;uid=root;password=;");
        //SqlConnection oSqlConnection = new SqlConnection("Initial Catalog=ComputerParts;Data Source=localhost;Integrated Security=SSPI;");
        string req="Select id_stat,titre_rubrique from table_stat ";
        MySqlCommand cmd = new MySqlCommand(req,conn);
        //cmd.Connection=conn;
        //cmd.CommandText=
        //SqlCommand oSqlCommand = new SqlCommand("GET_COMPUTER_PARTS", oSqlConnection);
        cmd.CommandType= CommandType.StoredProcedure;
        //oSqlCommand.CommandType = CommandType.StoredProcedure;
        DataSet dataset = new DataSet();
       // DataSet oResultDataset = new DataSet();
        MySqlDataAdapter adapter=new MySqlDataAdapter(cmd);
        //SqlDataAdapter oDataAdapter = new SqlDataAdapter(oSqlCommand);
        adapter.Fill(dataset);
        //oDataAdapter.Fill(oResultDataset);
 
        oChart.SVGDataSource = dataset.Tables[0];
        oChart.SVGDynamic = true;
        oChart.SVGWidthCM = 15;
        oChart.SVGHeightCM = 10;
        oChart.SVGFontHeightRatio = 1.7;
        oChart.SVGLabels = true;
        oChart.SVGLabelRadialDistance = 0.75f;
        oChart.SVGLegendSizePercentage = 35;
        oChart.SVGLabelRadialDivisor = 16.0f;
        oChart.CaptionField = "RUBRIQUE";
        oChart.ValueField = "NOMBRE";
        oChart.SVGXML.Save(Context.Response.OutputStream);
    } | 
Partager