C# WinForm listView 多行删除操作

最新推荐文章于 2026-06-18 20:35:03 发布

转载最新推荐文章于 2026-06-18 20:35:03 发布 · 400 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

原文链接：http://www.cnblogs.com/tskin/p/4096454.html

标签

#c# #数据库

本文介绍了如何使用C#实现从ListView中移除选定项及从数据库中删除选定记录的功能。通过示例代码展示了如何构建对话框确认删除操作，执行SQL删除语句，并更新UI。

//Button Delete , delete selected items from database

private void buttonDelete_Click(object sender, EventArgs e)
{
    DialogResult dr = MessageBox.Show("Are you sure to delete selected items? ", this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
    if (dr == DialogResult.OK)
    {
        try
        {
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();                               

                using (SqlCommand cmd = conn.CreateCommand())
                {
                    string sql = "";
                    string id = "";
                    foreach (ListViewItem item in this.listView1.SelectedItems)
                    {
                        id = item.SubItems[0].Text.Trim();// 0 is the index of id column in listView1
                        sql = 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 listView1
private void buttonRemove_Click(object sender, EventArgs e)
{
    foreach (ListViewItem item in this.listView1.SelectedItems)
    {
        if (item.Selected)
        {
            item.Remove();
        }
    }
    this.listView1.Refresh();
}

 

//Function Fresh Data, write by your self

private void FreshData(SqlConnection conn)
{
}