using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"]!= null)
{
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["conn"]);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter("select * from img where imgid=" + Request.QueryString["id"].Trim(), conn);
DataSet ds = new DataSet();
cmd.Fill(ds, "img");
if (ds.Tables["img"].Rows.Count > 0)
{
try
{
DataRowView drv = ds.Tables["img"].DefaultView[0];
string path = drv.Row["imgpath"].ToString();
File.Delete(path);
SqlCommand cmds = new SqlCommand("delete from img where imgid=" + Request.QueryString["id"].Trim(), conn);
cmds.ExecuteNonQuery();
Response.Write("<script>alert('删除成功!')</script>");
}
catch (Exception ex)
{
Response.Write(ex);
}
finally
{
conn.Close();
}
}
else
{
Response.Redirect("login.aspx");
}
}
}
}我初学者,刚学习.net做呢也是用的ASP的思路,大家也就不要笑,在到删除图片那一步比如是5.jpg那张图片就报错"System.IO.DirectoryNotFoundException: 未能找到路径“c:\Program Files\Microsoft Visual Studio 8\Common7\IDE\img\3.jpg”的一部分"但是我数据库里存的路径是img\5.jpg,为什么把软件的安装目录给加上去了。大侠求解。
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"]!= null)
{
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["conn"]);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter("select * from img where imgid=" + Request.QueryString["id"].Trim(), conn);
DataSet ds = new DataSet();
cmd.Fill(ds, "img");
if (ds.Tables["img"].Rows.Count > 0)
{
try
{
DataRowView drv = ds.Tables["img"].DefaultView[0];
string path = drv.Row["imgpath"].ToString();
File.Delete(path);
SqlCommand cmds = new SqlCommand("delete from img where imgid=" + Request.QueryString["id"].Trim(), conn);
cmds.ExecuteNonQuery();
Response.Write("<script>alert('删除成功!')</script>");
}
catch (Exception ex)
{
Response.Write(ex);
}
finally
{
conn.Close();
}
}
else
{
Response.Redirect("login.aspx");
}
}
}
}我初学者,刚学习.net做呢也是用的ASP的思路,大家也就不要笑,在到删除图片那一步比如是5.jpg那张图片就报错"System.IO.DirectoryNotFoundException: 未能找到路径“c:\Program Files\Microsoft Visual Studio 8\Common7\IDE\img\3.jpg”的一部分"但是我数据库里存的路径是img\5.jpg,为什么把软件的安装目录给加上去了。大侠求解。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货