SqlCommandBuilder 删除多笔记录

const string conn = @"user=sa;pwd=AbzQ75691;database=erp;server=192.168.2.20";
foreach (DataGridViewRow gvr in dataGridView1.Rows)
{
    var con = new SqlConnection(conn);
    var adapter = new SqlDataAdapter
    {
        DeleteCommand = new SqlCommand(string.Format("delete from [escale_std] where  identifier= '{0}'",gvr.Cells[0].Value.ToString().Trim()), con)
    };
    con.Open();
    adapter.DeleteCommand.ExecuteNonQuery(); //先删除后导入数据
    con.Close();
}