multipledelete

vergel aranas

Hi Sir, I'm here again hopping for your help. Sir, how can i delete multiple row in list view with mysql? I have already a code for deleting but it work only in one row and when i check and select more than one row it doesn't. How can i do that sir. Here is my code for delete.

        private void btnPdel_Click(object sender, EventArgs e)
        {


            foreach(int t in petlist.CheckedIndices)
            {
                string s = petlist.Items[t].Text.ToString();

                if (petlist.SelectedItems.Count > 0 )
                {
                    ListViewItem lv = petlist.SelectedItems[0];

                    string cid = lv.SubItems[6].Text;

                    string petdel = "Delete from petreg where petId = '" + s + "' and clientId ='" + cid + "'";
                    MySqlConnection connect = new MySqlConnection(conn);
                    MySqlCommand cmd = new MySqlCommand(petdel, connect);

                    connect.Open();
                    int execute = 0;
                    execute = cmd.ExecuteNonQuery();
                    connect.Close();
                    if (execute.Equals(1))
                    {
                        petload();
                        MessageBox.Show("Data was succesfully deleted", "Mysql says...", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    }
                    else
                    {
                        MessageBox.Show("The data is protected", "Error message", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                    }
                }

            }

        }

Thanks Sir.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
hi,

try following code.......
// using this you can only find checked item list
ListView.CheckedListViewItemCollection checkedItems = listView1.CheckedItems;
foreach (ListViewItem item in checkedItems)
{
    // This will fill the list with ListViewItems that are checked
    // In item.Text you can find name list item
    //write your delete logic
}

please refer....
http://msdn.microsoft.com/en-us/library/system.windows.forms.listview.checkboxes.aspx

hope this will help you.
vergel aranas14y ago
Hi sir, thank you so much for your reply. Sir i just want to clarify That i am using a listview and the checkbox is TRUE. How to do that sir in multiple deleting? I'm sorry sir i am really a beginner in c#.net.
Jignesh Trivedi14y ago
hi,

I assume that you use Checkbox list control.

try
for (var i = 0; i <= (checkedListBox1.Items.Count - 1); i++)
{
    if (checkedListBox1.GetItemChecked(i))
    {
        // Here you only find item if it is selected.
        // write your delete code.
        Console.WriteLine(checkedListBox1.Items[i].ToString());
    }
}

hope this will help you.
vergel aranas14y ago
Winform sir. c#.net 2008.
Jignesh Trivedi14y ago
hi vergel aranas,

Can please provide information about, which control are you using in your application and also technology like winform or web?

thx.