lv1=new listView
lv1.Items.Clear();
for (int m = 0; m < strali.Count; m++)
{
string strsql1 = "SELECT * FROM [Stock-S] WHERE [goodsname]='" + strali[m] + "' ";
string strConnect1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\cangku.mdb";
OleDbConnection aConnection1 = new OleDbConnection(strConnect1);
OleDbCommand aCommand1 = new OleDbCommand(strsql1, aConnection1);
try
{
aConnection1.Open();
OleDbDataReader aReader1 = aCommand1.ExecuteReader();
while (aReader1.Read())
{
ListViewItem li = new ListViewItem();
li.SubItems[0].Text = aReader1["goodsname"].ToString();
li.SubItems.Add(aReader1["Sum"].ToString());
li.SubItems.Add(aReader1["spec"].ToString());
li.SubItems.Add(aReader1["lastUpDataUser"].ToString());
li.SubItems.Add(aReader1["lastUpDate"].ToString()); lv1.Items.Add(li);
}
//关闭reader对象
aReader1.Close();
//关闭连接,这很重要
this.Controls.Add(lv1);
aConnection1.Close(); }
//一些通常的异常处理 catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
}
当我把检索条件重新变化的时候,,,,以前检索出来的条件没有Clear掉,检索出来的条件与新检索出来的条件一起显示出来了!怎么办~~>>
lv1.Items.Clear();
for (int m = 0; m < strali.Count; m++)
{
string strsql1 = "SELECT * FROM [Stock-S] WHERE [goodsname]='" + strali[m] + "' ";
string strConnect1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\cangku.mdb";
OleDbConnection aConnection1 = new OleDbConnection(strConnect1);
OleDbCommand aCommand1 = new OleDbCommand(strsql1, aConnection1);
try
{
aConnection1.Open();
OleDbDataReader aReader1 = aCommand1.ExecuteReader();
while (aReader1.Read())
{
ListViewItem li = new ListViewItem();
li.SubItems[0].Text = aReader1["goodsname"].ToString();
li.SubItems.Add(aReader1["Sum"].ToString());
li.SubItems.Add(aReader1["spec"].ToString());
li.SubItems.Add(aReader1["lastUpDataUser"].ToString());
li.SubItems.Add(aReader1["lastUpDate"].ToString()); lv1.Items.Add(li);
}
//关闭reader对象
aReader1.Close();
//关闭连接,这很重要
this.Controls.Add(lv1);
aConnection1.Close(); }
//一些通常的异常处理 catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
}
当我把检索条件重新变化的时候,,,,以前检索出来的条件没有Clear掉,检索出来的条件与新检索出来的条件一起显示出来了!怎么办~~>>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货