我在使用listview的时候遇到这样一个问题:
if (comboBox2.SelectedItem != null && comboBox3.SelectedItem != null && comboBox4.SelectedItem != null && comboBox5.SelectedItem != null)
{
string combo_sql = "select ip,webpagename,httpserv,ftpserv,bbsserv,blogserv from networkscan_table where httpserv='" + comboBox2.SelectedItem + "'and ftpserv='"+comboBox3.SelectedItem+"'and bbsserv='"+comboBox4.SelectedItem+"'and blogserv='"+comboBox5.SelectedItem+"'";
//string combo_sql = "select * from networkscan_table where httpserv='" + comboBox2.SelectedItem + "'and ftpserv='" + comboBox3.SelectedItem + "'and bbsserv='" + comboBox4.SelectedItem + "'and blogserv='" + comboBox5.SelectedItem + "'";
OleDbCommand cmd = new OleDbCommand(combo_sql, conn);
OleDbDataReader dr = cmd.ExecuteReader();
ListViewItem MyItem = new ListViewItem();
//MyItem.SubItems.Clear();
while (dr.Read())
{ MyItem.Text = dr.GetString(0); MyItem.SubItems.Add(dr["column1"].ToString());
MyItem.SubItems.Add(dr["column2"].ToString());
MyItem.SubItems.Add(dr["column3"].ToString());
MyItem.SubItems.Add(dr["column4"].ToString());
MyItem.SubItems.Add(dr["column5"].ToString());
//MyItem.SubItems.Add(dr["column6"].ToString()); listView1.Items.Add(MyItem);
}
conn.Close();
}以上代码在一个按钮单击事件中,当单击按钮时,在listView1.Items.Add(MyItem);处报错:不能在多处添加或插入项,请问大家有没有什么解决办法?谢谢.
if (comboBox2.SelectedItem != null && comboBox3.SelectedItem != null && comboBox4.SelectedItem != null && comboBox5.SelectedItem != null)
{
string combo_sql = "select ip,webpagename,httpserv,ftpserv,bbsserv,blogserv from networkscan_table where httpserv='" + comboBox2.SelectedItem + "'and ftpserv='"+comboBox3.SelectedItem+"'and bbsserv='"+comboBox4.SelectedItem+"'and blogserv='"+comboBox5.SelectedItem+"'";
//string combo_sql = "select * from networkscan_table where httpserv='" + comboBox2.SelectedItem + "'and ftpserv='" + comboBox3.SelectedItem + "'and bbsserv='" + comboBox4.SelectedItem + "'and blogserv='" + comboBox5.SelectedItem + "'";
OleDbCommand cmd = new OleDbCommand(combo_sql, conn);
OleDbDataReader dr = cmd.ExecuteReader();
ListViewItem MyItem = new ListViewItem();
//MyItem.SubItems.Clear();
while (dr.Read())
{ MyItem.Text = dr.GetString(0); MyItem.SubItems.Add(dr["column1"].ToString());
MyItem.SubItems.Add(dr["column2"].ToString());
MyItem.SubItems.Add(dr["column3"].ToString());
MyItem.SubItems.Add(dr["column4"].ToString());
MyItem.SubItems.Add(dr["column5"].ToString());
//MyItem.SubItems.Add(dr["column6"].ToString()); listView1.Items.Add(MyItem);
}
conn.Close();
}以上代码在一个按钮单击事件中,当单击按钮时,在listView1.Items.Add(MyItem);处报错:不能在多处添加或插入项,请问大家有没有什么解决办法?谢谢.
放到while里面