在图表中，x轴代表类别，y轴代表数值（好比类与他们的属性）
这是数据库中的数据，下面我们选前5辆车，在图表中显示他们的名字，油耗，功率，价格
创建查询数据的类
class CarDA { public List < CarData> select() { List < CarData > list= null; SqlConnection conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=123"); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select top 5* from car"; SqlDataReader dr= cmd.ExecuteReader() ; if(dr.HasRows) { list = new List<CarData>(); while(dr.Read()) { CarData data = new CarData(); data = new CarData(); data.Name = dr["name"].ToString(); data.Oil=(decimal)dr["oil"]; data.Powers=dr["powers"].ToString(); data.Price=(decimal )dr["price"]; list.Add(data); } } return list; cmd.Dispose(); conn.Close(); } }
class CarData { private string _name; public string Name { get { return _name; } set { _name = value; } } private decimal _oil; public decimal Oil { get { return _oil; } set { _oil = value; } } private string _powers; public string Powers { get { return _powers; } set { _powers = value; } } private decimal _price; public decimal Price { get { return _price; } set { _price = value; } } }
窗体一加载，给图表绑定数据，注意：绑定时以一列为单位，指明每列的x轴和y轴分别代表什么；
private void Form1_Load(object sender, EventArgs e) { List<CarData> list = new CarDA().select(); if (list != null) { chart1.DataSource = list; chart1.Series["Series1"].XValueMember="name"; chart1.Series["Series1"].YValueMembers = "oil"; } }
在Series属性里，可以设置每列的显示名字，并添加新列
private void Form1_Load(object sender, EventArgs e) { List<CarData> list = new CarDA().select(); if (list != null) { chart1.DataSource = list; chart1.Series["油耗"].XValueMember="name"; chart1.Series["油耗"].YValueMembers = "oil"; chart1.Series["功率"].XValueMember = "name"; chart1.Series["功率"].YValueMembers = "powers"; chart1.Series["价格"].XValueMember = "name"; chart1.Series["价格"].YValueMembers = "price"; } }
原文：http://www.cnblogs.com/wllhq/p/4370312.html