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)