listView1.Items.Remove(listView1.SelectedItems[0]);

解决方案 »

  1.   

    SqlCommand selectCmd=con.CreateCommand();
    selectCmd.CommandText="select * from tArticle"; SqlCommand deleteCmd=con.CreateCommand();
    deleteCmd.CommandText="delete from tArticle where id=@id";
    deleteCmd.Parameters.Add("@id",SqlDbType.Int,4,"id"); SqlDataAdapter sqlDataAdapter=new SqlDataAdapter();
    DataSet dataSet=new DataSet();
    sqlDataAdapter.SelectCommand=selectCmd;
    sqlDataAdapter.DeleteCommand=deleteCmd;

    con.Open();
    sqlDataAdapter.Fill(dataSet,"tArticle");
    con.Close(); DataTable dataTable=dataSet.Tables["tArticle"];
    dataTable.PrimaryKey=new DataColumn[]
    {
    dataTable.Columns["id"]
    };
    //dataTable.Rows.Find(
    string id;
    for(int i=0;i<lstArticle.Items.Count;i++)
    {
    if(lstArticle.Items[i].Checked==true)
    {
    id=lstArticle.Items[i].Text;
    DataRow dataRow=dataTable.Rows.Find(Convert.ToInt32(id)); if(dataRow!=null)
    dataRow.Delete();
    }

    }
    con.Open();
                sqlDataAdapter.Update(dataTable);
    con.Close();