如何将数据表绑定到MS图表
问题描述:
这是myCode:
private void frmChart_Load(object sender, EventArgs e)
{
string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;
using (SqlConnection Con = new SqlConnection(cs))
{
SqlCommand cmdSum = new SqlCommand("Select distinct(UserName),sum(Value) from mytable group by UserName",Con);
Con.Open();
SqlDataReader reader = cmdSum.ExecuteReader();
chart1.DataBindTable(reader,"sum(Value)");
}
foreach (Series series in chart1.Series)
{
series.CustomProperties = "DrawingStyle=LightToDark";
}
}
它向我显示了chart1.DatabindTable中的错误.我也尝试了另一种方法,但是我无法处理它.
It shows me an error in chart1.DatabindTable. also I try another method but I could not handle it.
答
如果您要做的只是绑定数据表,则只需执行以下操作:
If all you're trying to do is to bind a data table, then just do this:
private void Form1_Load(object sender, EventArgs e)
{
string sql = "your sql here";
SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString);
DataTable dt = new DataTable();
adapter.Fill(dt);
chart1.DataBindTable(dt.DefaultView, "UserName");
}
请注意,在调用DataBindTable
时,必须使用用户名"(xField
).不是Value
或Sum(Value)
.
Note when calling DataBindTable
you have to use "UserName" (xField
). Not Value
or Sum(Value)
.