C # WinForm ListView multi-row Delete operation

//Button Delete, delete selected items from databasePrivate voidButtondelete_click (Objectsender, EventArgs e) {DialogResult Dr= MessageBox.Show ("Is sure to delete selected items?", This.    Text, Messageboxbuttons.okcancel, messageboxicon.question); if(dr = =DialogResult.OK) {Try        {            using(SqlConnection conn =NewSqlConnection (connectionString)) {Conn.                                               Open (); using(SqlCommand cmd =Conn. CreateCommand ()) {stringsql =""; stringID =""; foreach(ListViewItem Iteminch  This. Listview1.selecteditems) {ID= Item. subitems[0]. Text.trim ();//0 is the index of ID, column in ListView1sql =string. Format ("Delete from users where id= ' {0} '", id); Cmd.commandtype=CommandType.Text; Cmd.commandtext=SQL; Cmd.                    ExecuteNonQuery ();            }} freshdata (conn); }        }        Catch(Exception ex) {MessageBox.Show (ex). ToString (), This.        Text); }    }} //Button Remove, remove selected items from ListView1Private voidButtonremove_click (Objectsender, EventArgs e) {    foreach(ListViewItem Iteminch  This. Listview1.selecteditems) {        if(item. Selected) {Item.        Remove (); }    }     This. Listview1.refresh ();} //Function Fresh Data, write by your selfPrivate voidFreshdata (SqlConnection conn) {}

C # WinForm ListView multi-row Delete operation