C#4.0 中Chart控件问题 VS 2010 中Chart控件数据源是Ilist<> 数据实体CreateDate 添加时间Price 是价格价格每天都有2010-1-1 到 2010-12-31该怎么绑定才能让 X轴是yyyy-MM 的形式 而Y轴是价格 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 private void CheckBoxList1_SelectedIndexChanged(object sender, System.EventArgs e) { this.Chart1.Visible=true; this.Chart1.Series.Clear(); string BDate=this.BDate.Value; string EDate=this.EDate.Value; DateTime dt1 = DateTime.Parse(BDate); DateTime dt2 = DateTime.Parse(EDate); TimeSpan ts = dt2 - dt1; string[] arr = new string[(int)ts.TotalDays+1]; for(int i=0;i<arr.Length;i++) { arr[i] = dt1.AddDays(i).ToString("yyyy-MM-dd"); } Series series; ChartArea area = Chart1.ChartAreas[0]; foreach (ListItem ltM in CheckBoxList1.Items) { if (ltM.Selected) { string connection=this.Label2.Text= ltM.Text.ToString(); SqlConnection con = new SqlConnection(ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con ; cmd.CommandTimeout = int.Parse( System.Configuration.ConfigurationSettings.AppSettings["conntimeout"].Trim()); cmd.CommandType = CommandType.Text;// string sql=SearchStr1(connection); cmd.CommandText = SearchStr1(connection); cmd.Connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); //DataTable dt = new DataTable(); DataSet dt = new DataSet(); adapter.Fill(dt,"chart"); DataTable dat=new DataTable(); dat=dt.Tables[0]; int len=dat.Rows.Count; string [] str1=new string[len]; double [] str2=new double[len]; for(int i=0;i<len;i++) { str1[i]=dat.Rows[i]["部門"].ToString(); str2[i]=Convert.ToDouble(dat.Rows[i]["出勤率"].ToString().Replace("%","")); } Chart1.Series.Add(connection); Chart1.Series[connection].Type = SeriesChartType.Line; //绑定才能让 X轴是日期格式 Chart1.Series[connection].Points.DataBindXY(arr,str2); int p=Chart1.Series[connection].Points.Count; for(int i =0;i<Chart1.Series[connection].Points.Count;i++) { Chart1.Series[connection].Points[i].MarkerStyle = MarkerStyle.Circle;//設置折點的風格// Chart1.Series[connection].Points[i].ShowInLegend = true; } Chart1.Series[connection].ToolTip = "X value \t= #VALX\nY value \t= #VALY{D}%"; } } } 独立主机配置MSSQL2005远程连接不上 Jquery 缺少对象 有些.net的网页在打开页面的时候并不现实.aspx后缀,而是html,请问这是怎么实现的? 关于从数据库中读取值的问题 点击预览后,页面上的Table消失了,如何解决? 如何去掉MultiLine的TextBox的滚动条? [问]一个分页的问题 问个小问题! 本机调试没有问题 上传到服务器有问题 asp.net中如何调用数据库中的存储过程呀??最好能举个小例子,带参数的!! 安装 netadvantage infragistics 2009 出错 除了aspnetpager,还有哪些实用的自定义控件?
{
this.Chart1.Visible=true;
this.Chart1.Series.Clear(); string BDate=this.BDate.Value;
string EDate=this.EDate.Value;
DateTime dt1 = DateTime.Parse(BDate);
DateTime dt2 = DateTime.Parse(EDate);
TimeSpan ts = dt2 - dt1;
string[] arr = new string[(int)ts.TotalDays+1];
for(int i=0;i<arr.Length;i++)
{
arr[i] = dt1.AddDays(i).ToString("yyyy-MM-dd");
} Series series;
ChartArea area = Chart1.ChartAreas[0];
foreach (ListItem ltM in CheckBoxList1.Items)
{
if (ltM.Selected)
{
string connection=this.Label2.Text= ltM.Text.ToString();
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con ;
cmd.CommandTimeout = int.Parse( System.Configuration.ConfigurationSettings.AppSettings["conntimeout"].Trim());
cmd.CommandType = CommandType.Text;
// string sql=SearchStr1(connection);
cmd.CommandText = SearchStr1(connection);
cmd.Connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
//DataTable dt = new DataTable();
DataSet dt = new DataSet();
adapter.Fill(dt,"chart");
DataTable dat=new DataTable();
dat=dt.Tables[0];
int len=dat.Rows.Count;
string [] str1=new string[len];
double [] str2=new double[len];
for(int i=0;i<len;i++)
{
str1[i]=dat.Rows[i]["部門"].ToString();
str2[i]=Convert.ToDouble(dat.Rows[i]["出勤率"].ToString().Replace("%",""));
}
Chart1.Series.Add(connection);
Chart1.Series[connection].Type = SeriesChartType.Line;
//绑定才能让 X轴是日期格式 Chart1.Series[connection].Points.DataBindXY(arr,str2);
int p=Chart1.Series[connection].Points.Count;
for(int i =0;i<Chart1.Series[connection].Points.Count;i++)
{
Chart1.Series[connection].Points[i].MarkerStyle = MarkerStyle.Circle;//設置折點的風格
// Chart1.Series[connection].Points[i].ShowInLegend = true;
}
Chart1.Series[connection].ToolTip = "X value \t= #VALX\nY value \t= #VALY{D}%";
}
}
}