c# - Asp.net 图表控件消失
问题描述
我在一个 aspx 页面上有四个图表控件。单击一个图表时,将出现下一个图表,因此我已在单击事件上绑定了所有图表。但是在第三张图表的点击事件中,第一张图表正在消失。所有其他点击事件都工作正常。下面是提到的代码:
protected void Chart3_Click(object sender, ImageMapEventArgs e)
{
string pointData = e.PostBackValue.Split(';')[0];
Session["pointvalue2"] = pointData;
BindChart1();
bindchart2();
BindChart3();
bindchart4();
}
public void BindChart1()
{
DateTime fromdate = Convert.ToDateTime(txtfromdate.Text);
string sqlFormattedDate = fromdate.ToString("yyyy-MM-dd HH:mm:ss.fff");
Session["fromdate"] = sqlFormattedDate;
DateTime todate = Convert.ToDateTime(txttodate.Text);
string sqlFormattedDate1 = todate.ToString("yyyy-MM-dd HH:mm:ss.fff");
Chart1.Visible = true;
string constr = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select col2 as 'col2', col1 as 'col1',col3 as 'col3' from dbo.table where APPLICATION = 'test' and col1 BETWEEN @fromdate AND @todate group by MONTH(col1),col2", conn);
cmd.Parameters.AddWithValue("@fromdate", sqlFormattedDate);
cmd.Parameters.AddWithValue("@todate", sqlFormattedDate1);
cmd.CommandType = CommandType.Text;
SqlDataReader rdr = cmd.ExecuteReader();
gvreport.DataSource = rdr;
gvreport.DataBind();
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("severity", typeof(string)));
dt.Columns.Add(new DataColumn("Count", typeof(int)));
dt.Columns.Add(new DataColumn("Time", typeof(int)));
foreach (GridViewRow row in gvreport.Rows)
{
DataRow dr = dt.NewRow();
dr["Count"] = Convert.ToInt32(row.Cells[0].Text);
dr["severity"] = row.Cells[1].Text;
dt.Rows.Add(dr);
}
DataTable ChartData = dt;
Chart1.DataSource = dt;
Session["dtTest"] = dt;
// Set series members names for the X and Y values
Chart1.Series["Series1"].XValueMember = "severity";
Chart1.Series["Series1"].YValueMembers = "Count";
// Data bind to the selected data source
Chart1.DataBind();
Chart1.Titles.Add("Chart");
Chart1.Series[0].ChartType = SeriesChartType.Pie;
Chart1.Series["Series1"]["PieLabelStyle"] = "Disabled";
Chart1.Series["Series1"].ToolTip = "Related_CI_Type: #VALX, Count: #VALY";
foreach (Series series in Chart1.Series)
{
series.PostBackValue = "#SERIESNAME;#VALX;#VALY";
}
Chart1.Visible = true;
}
请建议。提前致谢。
解决方案
推荐阅读
- html - 如何指定绝对路径?
- php - Laravel 日期格式和控制台
- python - 尽管已安装,但没有名为 import_export 的模块
- php - Laravel 策略自动检测
- html - 需要帮助将一些内容居中
- ibm-cloud - quotacheck:您的内核可能支持日志配额,但您没有使用它
- javascript - 循环内的 Firebase 实时数据库侦听器无法正常工作
- java - 为什么localhost中的script.js与根目录中的script.js不同
- python-3.x - 使用 multiprocessing.pool 加载 keras 模型导致预测“ValueError Tensor Tensor”
- html - 在手机和其他小屏幕尺寸中查看时,我网站的背景图片不成比例