62,067
社区成员
发帖
与我相关
我的任务
分享
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
ConfChart();
}
}
chart#region chart
private DataTable CreateDataTable()
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConString"]);
SqlDataAdapter adapter = new SqlDataAdapter();
string selectQuery = @"select newdate,count(PK_ID) as allcount from "
+"(select convert(varchar(10),fld_createtime,120) as newdate,* from FEEDBACK_FB_TAB where 1=1";
if (this.txt_StartTime.Text != "")
selectQuery += " and fld_createtime>"+Common.QuotedStr(txt_StartTime.Text+" 00:00:00");
if (this.txt_endtime.Text != "")
selectQuery += " and fld_createtime<"+Common.QuotedStr(txt_endtime.Text+" 23:59:59");
selectQuery += ") as t1 group by t1.newdate";
adapter.SelectCommand = new SqlCommand(selectQuery, conn);
adapter.Fill(dt);
return dt;
}
private void ConfChart()
{
Chart1.Debug = false;
Chart1.Mentor = false;
Chart1.Title="客户反馈日统计图";
//Chart1.XAxis.Label.Text="日期";
Chart1.YAxis.Label.Text="反馈次数";
Chart1.TempDirectory="temp";
Chart1.ShadingEffect = true;
Chart1.Use3D = true;
Chart1.Width = 600;
Chart1.Height = 350;
Chart1.Series.Name = "客户反馈次数";
Chart1.Series.Data = CreateDataTable();
Chart1.SeriesCollection.Add();
}
#endregion
http://www.cnblogs.com/stylenocall/archive/2011/01/17/1937127.html
希望对你帮助。如果要源代码联系我