我用linq to sql指定了数据源
var myResult = from s in faqs.Score
where s.answerDate >= Convert.ToDateTime(txtStartDate.Text.Trim()) && s.answerDate <= Convert.ToDateTime(txtEndDate.Text.Trim())
&& s.Member.Group.Department.departmentID == Convert.ToInt32(dropDepartMent.SelectedItem.Value)
&& s.scores >= 60
group s by s.Member.Group.groupName into g
select new {
xx = g.Key,
ff = faqs.Member.Count( x=> x.Group.groupName == g.Key ) / g.Count()
};
现在想用chart控件展示数据,如何指定? ChartScores.DataSource = myResult;
//下面这两行如何指定?
ChartScores.Series["?"].XValueMember = "xx";
ChartScores.Series["?"].YValueMembers = "ff";
ChartScores.DataBind();
var myResult = from s in faqs.Score
where s.answerDate >= Convert.ToDateTime(txtStartDate.Text.Trim()) && s.answerDate <= Convert.ToDateTime(txtEndDate.Text.Trim())
&& s.Member.Group.Department.departmentID == Convert.ToInt32(dropDepartMent.SelectedItem.Value)
&& s.scores >= 60
group s by s.Member.Group.groupName into g
select new {
xx = g.Key,
ff = faqs.Member.Count( x=> x.Group.groupName == g.Key ) / g.Count()
};
现在想用chart控件展示数据,如何指定? ChartScores.DataSource = myResult;
//下面这两行如何指定?
ChartScores.Series["?"].XValueMember = "xx";
ChartScores.Series["?"].YValueMembers = "ff";
ChartScores.DataBind();
this.chart1.Series["Series1"].Points.AddXY(xx, ff);
ChartScores.Series[0].YValueMembers = "ff";简单的用法