C# WinForm listView 多行删除 操作
来源:互联网 发布:2017年轻人数据报告 编辑:程序博客网 时间:2024/05/25 23:25
//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)
{
}
- C# WinForm listView 多行删除 操作
- WinForm的listView多行删除操作
- C# winform文件夹操作复制和删除
- Winform c# listview行高的设置
- Winform c# listview行高的设置
- C# Winform ListView使用
- C# winform: 初始化ListView
- C# Winform ListView使用
- c# listview删除多选项
- C# winform中ListView用法
- C# winform中ListView用法
- C# winform中ListView用法
- C# winform中ListView用法
- C# winform中ListView用法
- C# winform中ListView用法
- c# winform listview 拖放排序
- C# winform中ListView用法
- C# winform中ListView用法
- PHP访问MySql数据库 初级篇
- 魔法赋值
- 关于每一个数据库表都应该有一个单一的字段作为主键的讨论
- MySQL的复制和临时表(Temporary Table)
- ADF Faces中如何跳过验证
- C# WinForm listView 多行删除 操作
- Java中super的几种用法并与this的区别
- (综合整理)Oracle优化
- 转义字符
- mssql转换为MySQL数据库经验漫谈
- Android managedQuery查询如果加入group by条件(及其猥琐的方法)
- BleuFlamme:利用3D渲染技术的衬衫DIY
- 什么是Single Sign On
- oracle数据库表的复制