private void show()
{
//string swf = "MSCombi3D.swf";
string swf = "Pie3D.swf";
StringBuilder nr = new StringBuilder();
nr.AppendFormat("<chart baseFont='宋体' caption='在职与离退休人员情况统计图(按单位性质统计)' baseFontSize='12'>");
sql1 = "";
sql1 取得数据 单位性质,在职人数,离退人数
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["dsn"].ToString());
SqlCommand cmd = new SqlCommand(sql1, conn);
SqlDataReader rd;
conn.Open();
rd = cmd.ExecuteReader();
while (rd.Read())
{
nr.AppendFormat("<set label='" + rd["content"].ToString() + "' value='" + rd["离职"].ToString() + "'/>");
}
rd.Close();
nr.AppendFormat("</chart>");
textchar.Text = FusionCharts.RenderChart("../comm/FusionCharts/Charts/" + swf, "", nr.ToString(), "chart1Id", "650", "400", false, true);
}
nr.AppendFormat怎么写可以实现按单位性质柱形图,一列双柱
数据如下