折线图形的数据库设计:
id int
name varchar(50)
dataTime datetime
饼形图和柱状图使用同一个表的数据:
id int
name varchar(50)
shuliang int
下面的ChartControl1、ChartControl2、ChartControl3都是从工具箱拖进页面的webChart控件的ID
1、折线图代码:(实现的为当年的按月份的趋势)
定义颜色:
1
2
3 private string [] myColor = new string []
4
5 {
6
7 " Tomato " , // 西红柿
8
9 " Black " ,
10
11 " Gold " ,
12
13 " Blue " ,
14
15 " Green " ,
16
17 " Orange " ,
18
19 " Pink " , // 粉红
20
21 " Violet " , // 紫罗兰
22
23 " Orchid " , // 淡紫色
24
25 " Lime " , // 亮绿
26
27 " Tan " , // 茶色
28
29 " Red " ,
30
31 " Navy " // 橘红
32
33 };
2
3 private string [] myColor = new string []
4
5 {
6
7 " Tomato " , // 西红柿
8
9 " Black " ,
10
11 " Gold " ,
12
13 " Blue " ,
14
15 " Green " ,
16
17 " Orange " ,
18
19 " Pink " , // 粉红
20
21 " Violet " , // 紫罗兰
22
23 " Orchid " , // 淡紫色
24
25 " Lime " , // 亮绿
26
27 " Tan " , // 茶色
28
29 " Red " ,
30
31 " Navy " // 橘红
32
33 };
给webChart绑定数据:
1
private
void
GetLineChart()
2
3 {
4
5 // 创建折线对象
6
7 LineChart myLineChart = new LineChart();
8
9 myLineChart.Line.Color = Color.FromName(myColor[ 0 ]);
10
11 myLineChart.Fill.Color = Color.FromName(myColor[ 0 ]);
12
13 myLineChart.LineMarker = new DiamondLineMarker( 8 ,Color.FromName(myColor[ 0 ]),Color.FromName(myColor[ 0 ]));
14
15 myLineChart.DataSource = GetData().DefaultView; // GetData()方法见下
16
17 myLineChart.DataXValueField = " mMonth "
2
3 {
4
5 // 创建折线对象
6
7 LineChart myLineChart = new LineChart();
8
9 myLineChart.Line.Color = Color.FromName(myColor[ 0 ]);
10
11 myLineChart.Fill.Color = Color.FromName(myColor[ 0 ]);
12
13 myLineChart.LineMarker = new DiamondLineMarker( 8 ,Color.FromName(myColor[ 0 ]),Color.FromName(myColor[ 0 ]));
14
15 myLineChart.DataSource = GetData().DefaultView; // GetData()方法见下
16
17 myLineChart.DataXValueField = " mMonth "