How To Delete Items From The List View?

By Goniey N (Mr. G)

At Runtime It Will Remove Items From The List View & Also From The Database...

-- I Use Below As Table :

MyTable
==================
ListId ListName
==================
1 LV1
2 LV2
3 LV3
4 LV4
5 LV5
==================



--To Delete Data From The Database Also For That Use Below Code :

private void button1_Click(object sender, EventArgs e)
{  
       System.Collections.ArrayList alv = new System.Collections.ArrayList();
        int i = 0;
        foreach (ListViewItem lv in listView1.SelectedItems)
        {
                 lv.Remove();
                 //Here It Will Store The Name Of The Listview Items....
                alv[i] = lv.Text.ToString();
                 i++;
        }
       OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<<Your Database Path>>");
       OleDbCommand cmd=new OleDbCommand();
        try
        {
                 for (i = 0; i < alv.Count; i++)
                 {
                         conn.Open();
                         //Depending On The Listview Name It Will Also Check That Arraylist Names In The Database & If It Is There Then Delete That Row...
                         cmd.CommandText = "DELETE FROM MyTable Where ListName='" + alv[i].ToString() + "'";
                         cmd.ExecuteNonQuery();
                         conn.Close();
                 }
        }
        catch(Exception ex)
        {
                 MessageBox.Show(ex.ToString());
        }
}

How To Delete Items From The List View?  (1158 Views)