刚参加工作的应届菜鸟求助

w87875251l 2010-11-10 10:04:32

http://blog.csdn.net/w87875251l/archive/2010/11/02/5983301.aspx
如图，我要实现第二张表，我把表中的列名抽象出一个类，
public class Data
{
public Data()
{
//
// TODO: 在此处添加构造函数逻辑
//
}

private string a;//公司
private int b;//安装代理总数
private int c;//共享目录中威胁数量
private int d;//若密码威胁数量
..........

public string A
{
get { return a; }
set { a = value; }
}
public int B
{
get { return b; }
set { b = value; }
}

public int C
{
}
其他的就省略了
public static Data conv(SqlDataReader dr)
{
Data t = new Data();
t.A = dr["Company"].ToString();
//t.B = dr["newsMsg"].ToString();
t.B = Convert.ToInt32 (dr["geshu"]);

return t;
}

.aspx.cs中写的是
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = test() ;
Repeater1.DataBind();
}
public ArrayList test()
{
//ArrayList list = new ArrayList();
SqlConnection conn = db.CreateConnection();
conn.Open();
string sql = "select count(computer_idn)as geshu,Company from (select a.Computer_idn,b.ComPany,a.Reason,a.Vulnerability_Idn from CVDetected a,(select a.*,b.company from computer a,(select b.computer_idn,a.Company,b.IpAddress from gongsia a,BoundAdapter b where left(a.IpAddress,12)=left(b.IpAddress,12) union select b.computer_idn,a.Company,b.IpAddress from gongsib a,BoundAdapter b where a.ipaddress=b.ipaddress) b where a.computer_idn=b.computer_idn ) b where a.computer_idn=b.computer_idn and a.Vulnerability_Idn=2671) a group by Company order by Company";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
list.Add(Data.conv(dr));
}
conn.Close();

return list;
}
属性值A,B,C。。。。即对应的列值，但是还要从数据库中的不同表查询字段，Arraylist还要添加列值，然后绑定repeater，我该怎么办？？

...全文

210 16 打赏收藏转发到动态举报

写回复

用AI写文章

16 条回复

切换为时间正序

请发表友善的回复…

发表回复

w87875251l 2010-11-10

打赏
举报

帮自己顶。。。

w87875251l 2010-11-10

打赏
举报

我的 qq 591811930

w87875251l 2010-11-10

打赏
举报

慕名而来，对方拒绝被添加啊，大哥

liffe 2010-11-10

打赏
举报

178666881

w87875251l 2010-11-10

打赏
举报

大哥，你qq多少，能加你吗？谢谢，好不容易找到一份工作

w87875251l 2010-11-10

打赏
举报

http://blog.csdn.net/w87875251l/archive/2010/11/10/5999245.aspx
表的结构

liffe 2010-11-10

打赏
举报

要你表结构，不要你的这写查询语句。想看一下你的表是如何设计的

w87875251l 2010-11-10

打赏
举报

-----共享目录检查中存在威胁数量select count(computer_idn)as geshu,Company from
(
select a.Computer_idn,b.ComPany,a.Reason,a.Vulnerability_Idn from CVDetected a,
(
select a.*,b.company from computer a,
(
select b.computer_idn,a.Company,b.IpAddress from gongsia a,BoundAdapter b where left(a.IpAddress,12)=left(b.IpAddress,12)
union
select b.computer_idn,a.Company,b.IpAddress from gongsib a,BoundAdapter b where

a.ipaddress=b.ipaddress

) b where a.computer_idn=b.computer_idn
) b where a.computer_idn=b.computer_idn and a.Vulnerability_Idn=2671
) a group by Company order by Company

----------安装代理总数
select count(computer_idn) as zongshu,company from
(select a.*,b.company from computer a,
(
select b.computer_idn,a.Company,b.IpAddress from gongsia a,BoundAdapter b where left(a.IpAddress,12)=left(b.IpAddress,12)
union
select b.computer_idn,a.Company,b.IpAddress from gongsib a,BoundAdapter b where a.ipaddress=b.ipaddress

) b where a.computer_idn=b.computer_idn and b.company in(select distinct d.company from computer c,
(select d.computer_idn,c.Company,d.IpAddress from gongsia c,BoundAdapter d where left(c.IpAddress,12)=left(d.IpAddress,12)
union
select d.computer_idn,c.Company,d.IpAddress from gongsib c,BoundAdapter d where

c.ipaddress=d.ipaddress
) d where c.computer_idn=d.computer_idn)
) a group by Company order by company

--若密码存在威胁数量
select count(computer_idn)as geshu,Company from
(
select a.Computer_idn,b.ComPany,a.Reason,a.Vulnerability_Idn from CVDetected a,
(
select a.*,b.company from computer a,
(
select b.computer_idn,a.Company,b.IpAddress from gongsia a,BoundAdapter b where left(a.IpAddress,12)=left(b.IpAddress,12)
union
select b.computer_idn,a.Company,b.IpAddress from gongsib a,BoundAdapter b where a.ipaddress=b.ipaddress

) b where a.computer_idn=b.computer_idn
) b where a.computer_idn=b.computer_idn and a.Vulnerability_Idn=2683
) a group by Company order by Company
等等。。就是每个字段对应一条sql语句