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);
} |
