在DATAGRID中如何进行多个数据同时删除的操作？

最新推荐文章于 2024-02-07 22:09:49 发布

cg2002

最新推荐文章于 2024-02-07 22:09:49 发布

阅读量372

点赞数

文章标签： datagrid string delete database button object

本文链接：https://blog.csdn.net/cg2002/article/details/1623639

版权

void Button_Click(...)
{
    string result = "";
    foreach(DataGridItem item in GridName.Items)
    {
        CheckBox chk = (CheckBox)item.FindControl(checkboxid);
        if(chk.checked)
            result += string.Format("'{0}',",item.cells[keyIndex].Text);
    }
    if(result != "")
        result = result.SubString(0,result.Length-1);
    string sql = string.Format("delete from TableName where key in ({0})",result);

....
}

private void btnDelete_Click(object sender, System.EventArgs e)
{
string whereClause = string.Empty;
foreach(DataGridItem dgi in DataGrid1.Items)
{
CheckBox chk = (CheckBox)dgi.FindControl("chkSelect");
if(chk != null)
{
if(chk.Checked)
{
if(whereClause == string.Empty)
whereClause += "'" + DataGrid1.DataKeys[dgi.ItemIndex].ToString() + "'";
else
whereClause += ",'" + DataGrid1.DataKeys[dgi.ItemIndex].ToString() + "'";
}
}
}
if(whereClause != string.Empty)
{
SqlConnection cn = new SqlConnection("server=.;uid=sa;pwd=;database=pubs");
string strSQL = "delete from authors where au_id in (" + whereClause + ")";
SqlCommand cmd = new SqlCommand(strSQL, cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
BindGrid();
}