string strCmd = "select cpuname,collecttime,ipaddr,idletime from cpu where cpuname='"+arrayCpuName[i-1].ToString()+"' and rownum<2 order by collecttime desc "; Console.WriteLine(strCmd); oleDbCommand=new OleDbCommand(strCmd,oleDbConnection); oleDbReader=oleDbCommand.ExecuteReader();while(oleDbReader.Read()) { listItems[0]=oleDbReader["cpuname"].ToString(); listItems[1]=oleDbReader["collecttime"].ToString(); listItems[2]=oleDbReader["ipaddr"].ToString(); listItems[3]=oleDbReader["idletime"].ToString();} oleDbReader.Close();listView1.Items.Insert(count,new ListViewItem(listItems)); count++; }
不要用ole了
{
string strCmd = "select cpuname,collecttime,ipaddr,idletime from cpu where cpuname='"+arrayCpuName[i-1].ToString()+"' and rownum<2 order by collecttime desc ";
Console.WriteLine(strCmd);
oleDbCommand=new OleDbCommand(strCmd,oleDbConnection);
oleDbReader=oleDbCommand.ExecuteReader();while(oleDbReader.Read())
{
listItems[0]=oleDbReader["cpuname"].ToString();
listItems[1]=oleDbReader["collecttime"].ToString();
listItems[2]=oleDbReader["ipaddr"].ToString();
listItems[3]=oleDbReader["idletime"].ToString();}
oleDbReader.Close();listView1.Items.Insert(count,new ListViewItem(listItems));
count++;
}