How do I use Listview to delete MySQL DB records

[kismetgerald]

Hello everyone,

I trust you're all doing well. My application has come a long way and is almost complete - can't wait to share it with you guys. There are two things left to do - create reports, and the second is what I'm asking about in this thread.

So, here's what I want to do and don't know how to - hope you can help:

I want to create a functionality that allows me to retrieve records from the MySQL DB, store the results in a Listview control, then use that along with some buttons to delete individual records or multiple records (either based on selecting multiple rows or checking multiple checkboxes provided by the control). In either case, I want to be able to show a confirmation dialog box before executing the query that will delete the records.

I'm really looking forward to your assistance with this. I am willing to make the entire solution and DB available if necessary.

Thanks.