foreach遍历删除问题:
foreach (DataListItem it in DL_img.Items)
{
CheckBox cb = (CheckBox)it.FindControl("c2");
if (cb.Checked == true)
{
string id = ((HiddenField)it.FindControl("h1")).Value;
string url = d.getSingle("select url from tb_img where id='" + id + "'", false).ToString();
d.getCount("delete tb_img where id='" + id + "'", false);
bind();
//删除本地图片
string phyPath = Server.MapPath(url);
FileInfo file = new FileInfo(phyPath);
if (file.Exists)
{
file.Delete();
}
}
}
这个原因是由于:遍历所选中的数据库时每次删除一行就要刷新,这样foreach正在遍历无法获取删除的则提示。
ArrayList a1 = new ArrayList();
foreach (DataListItem it in DL_img.Items)
{
CheckBox cb = (CheckBox)it.FindControl("c2");
int i = 0;
if (cb.Checked == true)
{
a1.Add(((HiddenField)it.FindControl("h1")).Value);
i++;
}
}
if (a1.Count > 0)
{
for (int i = 0; i < a1.Count; i++)
{
//if (!String.IsNullOrEmpty(a1[i].ToString()))
//{
string url = d.getSingle("select url from tb_img where id='" + a1[i].ToString() + "'", false).ToString();
//}
d.getCount("delete tb_img where id='" + a1[i].ToString() + "'", false);
//删除本地图片
string phyPath = Server.MapPath(url);
FileInfo file = new FileInfo(phyPath);
if (file.Exists)
{
file.Delete();
}
}
bind();
}