Zedgraph控件在C#winForm中的该如何应用

[hexiaoying_youxiang]

已经生成了柱状图可是没有和数据库绑定该如何与数据库绑定 是它的柱高与数据库中的数据相对应 以下是随机的柱高代码有谁可以帮忙修改一下 让它与数据库表联系吗

public void CreateChart(ZedGraphControl zgc)
{
GraphPane myPane = zgc.GraphPane;

//设置图表的说明文字

myPane.Title.Text = "2010年上半年财务报表";
//myPane.XAxis.Title.Text = "月份";
myPane.YAxis.Title.Text = "盈利情况"; //设置纵坐标的说明文字
myPane.YAxis.IsVisible = true;
myPane.XAxis.IsVisible = true;
string[] labels = { "1月", "2月", "3月", "4月", "5月", "6月" };//设置横坐标的文字
myPane.XAxis.Scale.TextLabels = labels;
myPane.XAxis.Type = AxisType.Text;

PointPairList list = new PointPairList();
PointPairList list2 = new PointPairList();
PointPairList list3 = new PointPairList();
PointPairList list4 = new PointPairList();
PointPairList list5 = new PointPairList();
PointPairList list6 = new PointPairList();
Random rand = new Random();
//string[] labels = new string[SaleDV.Rows.Count];

//for (int i = 0; i < this.SaleDV.Rows.Count; i++)
string sql = "select　gapmoney,Spinpai from sale_tb";

// 设置横坐标个数
for (int i = 1; i < 7; i++)
{

//SqlConnection mycon = new SqlConnection("server=.;database=softDB;uid=sa;pwd=123;");
//mycon.Open();
//SqlCommand sele = new SqlCommand("select gapmoney from sale_tb", mycon);
//SqlDataReader dt = sele.ExecuteReader();
//dt.Read();
double x = (double)i;
double y = 100;//double .Parse (dt [0].ToString ()) ;
double y2 = rand.NextDouble() * 1000;
double y3 = rand.NextDouble() * 1000;
double y4 = rand.NextDouble() * 1000;
double y5 = rand.NextDouble() * 1000;
double y6 = rand.NextDouble() * 1000;
list.Add(x, y);
list2.Add(x, y2);
list3.Add(x, y3);
list4.Add(x, y4);
list5.Add(x, y5);
list6.Add(x, y6);
}

//创建每个bar

BarItem myCurve = myPane.AddBar("诺基亚手机", list, Color.Blue);
BarItem myCurve2 = myPane.AddBar("三星手机", list2, Color.Red);
BarItem myCurve3 = myPane.AddBar("步步高手机", list3, Color.Green);
BarItem myCurve4 = myPane.AddBar("电信手机", list4, Color.Yellow );
BarItem myCurve5 = myPane.AddBar("CDMA手机", list5, Color.SaddleBrown);
BarItem myCurve6 = myPane.AddBar("其他杂牌手机", list6, Color.Orange);





// 设置图标的颜色和渐变色

myPane.Chart.Fill = new Fill(Color.White,
Color.FromArgb(255, 255, 166), 45.0F);

zgc.AxisChange();
// expand the range of the Y axis slightly to accommodate the labels
myPane.YAxis.Scale.Max += myPane.YAxis.Scale.MajorStep;

// 创建每条bar的label,其中第2个参数表示是否显示在bar的中心位置，第3个参数表示label的排列方向

BarItem.CreateBarLabels(myPane, false, "f0");

}

[轮销桂魄@]

这个没直接的数据源绑定 你得做个循环 然后把数据绑定上去