create table AA
(
c_parameterName varchar(100), --名称
c_homologyCount int, --一致数
c_differCount int --不一致数
)
select * from AA
insert into AA values('Force2Phase',9,6)
insert into AA values('CHREQCSMAXMSGNUMINPERIOD',19,86)
insert into AA values('STARTCHREQARRIVALCTRL',96,64)
insert into AA values('FORBIDEDGU',99,66)
insert into AA values('ALLOCDIFFTRX',92,67)
insert into AA values('PGCLASSIFINGALLOWED',9,99)
insert into AA values('T3212',22,6)
柱状图显示的格式为:每一个网元对应一致数和不一致数
(
c_parameterName varchar(100), --名称
c_homologyCount int, --一致数
c_differCount int --不一致数
)
select * from AA
insert into AA values('Force2Phase',9,6)
insert into AA values('CHREQCSMAXMSGNUMINPERIOD',19,86)
insert into AA values('STARTCHREQARRIVALCTRL',96,64)
insert into AA values('FORBIDEDGU',99,66)
insert into AA values('ALLOCDIFFTRX',92,67)
insert into AA values('PGCLASSIFINGALLOWED',9,99)
insert into AA values('T3212',22,6)
柱状图显示的格式为:每一个网元对应一致数和不一致数
后台代码
/// <summary>
/// 绘制图表OWC线性图形
/// </summary>
public void GetOWCIamge()
{
//把连接字串指定为一个常量
SqlConnection Con = new SqlConnection("Server=20110128-1416;Database=TestNetResAn;Uid=sa;Pwd=exusoft");
Con.Open();
string cmdtxt = "select c_parameterName,c_homologyCount,c_differCount from t_parameterCollect";
SqlCommand Com = new SqlCommand(cmdtxt, Con); //10.
DataSet ds = new DataSet();
SqlDataAdapter Da = new SqlDataAdapter(cmdtxt, Con);
Da.Fill(ds);
DataTable dt = ds.Tables[0];
string[] rows = new string[dt.Rows.Count];
string[] columns = new string[dt.Rows.Count];
string[] ss = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
rows[i] = dt.Rows[i]["c_homologyCount"].ToString();
columns[i] = dt.Rows[i]["c_differCount"].ToString();
ss[i] = dt.Rows[i]["c_parameterName"].ToString();
} OWCImageHelp.ShowOWCImage(dt, PlaceHolder1, rows, columns, "柱状图");
Con.Close();
}前台代码:
<table style="width: 600px">
<tr>
<td style="height: 21px; width: 502px;" align="center">
<asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>
</td>
</tr>
</table>