关于C#winform平台listview控件删除数据
private void 删除文件ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (filesList.SelectedItems.Count != 0)
{
DialogResult dlgResult;
dlgResult = MessageBox.Show("确定要删除该组?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk);
if (dlgResult == DialogResult.Yes)
{
string conn = "Data Source=(local);Initial Catalog=edg;Integrated Security=True";
SqlConnection connection = new SqlConnection(conn);
connection.Open();
string select = this.filesList.SelectedItems[0].Text.ToString();
string sql ="delete from 科普活动 where ID="+"'"+select+"'";
SqlCommand cmd = new SqlCommand(sql, connection);
filesList.SelectedItems[0].Remove();
MessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//MessageBox.Show(listView1.SelectedItems[0].Text);
}
}
else
MessageBox.Show("请先选择要删除的组名!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
为什么我的代码只能删除控件里的数据,数据库里的数据没有删掉.....sql语句调试后复制到数据库也没问题....