62,242
社区成员




DataTable dt = new DataTable();
dt.Columns.Add("DateValue", typeof(DateTime));
dt.Rows.Add("2010-10-20");
dt.Rows.Add("2011-07-28");
dt.Columns.Add("NewCol", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["NewCol"] = Convert.ToDateTime(dt.Rows[i]["DateValue"].ToString()).ToString("yyyy-MM-dd");
}
dt.AcceptChanges();
Chart1.DataSource = dt;
Chart1.Series["Series1"].XValueMember = "NewCol";
/*
DateValue NewCol
2010-10-20 0:00:00 2010-10-20
2011-7-28 0:00:00 2011-07-28
*/
--例如这种:
select ltirm(convert(crdtm,date)) as crdtm from table;
select convert(crdtm,date)as crdtm from table;
+------------+
| crdtm |
+------------+
| 2010-10-20 |
| 2011-07-28 |
+------------+
2 rows in set
Chart1.Series["Series3"].MarkerColor = Color.Blue;
Chart1.Series["Series3"].MarkerBorderColor = Color.Blue;
Chart1.Series["Series3"].MarkerStyle = MarkerStyle.Triangle;
Chart1.Series["Series3"].MarkerSize = 8;
Chart1.Series["Series3"].LabelFormat = "0.#";//类型这里。
//数据库中的数据,当你得到dt后,把dt放到MSchart的DataSource就可以了
//这样就只得到dt的数据,而不是数据库中的数据了。
DataTable dt = new DataTable();
TestData tda = new TestData();
dt = tda.GetTestData();
Chart1.DataSource = dt;