Question

C#删除上传文件并且在数据库删除记录

我是新手,求助高手个问题 ,我想删除数据库里一条记录 同时删除dbImgs目路下的文件 文件的名字是和数据库里的FileName字段下的名字一样的 求高手指点 最好能给出代码

Answer 1

if(!string.IsNullOrEmpty(FileName))
{
string conn="Provider=SQLNCLI;Server=localhost\\SQLEXPRESS;Database=数据库名称;UID=用户名称;PWD=密码;";
string sql="";
string file = Application.StartupPath+"\\dbImgs\\"+FileName+".jpg";
System.IO.File.Delete(file);

sql="delete from 表名称 where FileName="+FileName;
ExeSql(conn,sql)
}
public int ExeSql(string conn,string Sql)
{
OleDbConnection myConnection = new OleDbConnection(conn);
OleDbCommand myCommand = new OleDbCommand(Sql, myConnection);
myCommand.CommandTimeout = 10000;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Dispose();
myConnection.Close();
return 1;
}
catch (Exception ex)
{
myConnection.Close();
MessageBox.Show(ex.Message + "\r\n" + Sql);
return 0;
}
}

Answer 2

先取得FileName
然后删记录
再
string file = Application.StartupPath+"\\dbImgs\\"+FileName;
System.IO.File.Delete(file);

Answer 3

"先取得FileName
然后删记录
再
string file = Application.StartupPath+""\\dbImgs\\""+FileName;
System.IO.File.Delete(file); "