asp.net已经实现文件的上传功能，但是怎么把上传文件的路径保存到数据库里的代码怎么写？还有怎么实现文件下载功能？

[ndsc1211]

上传文件用的是fileupload控件，代码是protected void upload_Click(object sender, EventArgs e)
{

if (upfile.HasFile)
{
string fname = upfile.PostedFile.FileName;
int fi = fname.LastIndexOf("\\") + 1;
string filename = fname.Substring(fi);
upfile.PostedFile.SaveAs(Server.MapPath("upload\\" + filename));
Response.Write("<script>alert('报名表上传成功！');</script>");
}
else
{
Response.Write("<script>alert('请选择您要上传的报名表！');</script>");
}

}
本人是新手，希望各位大虾多多指教。。

[huangwenquan123]

protected void upload_Click(object sender, EventArgs e)
  {
  if (upfile.HasFile)
  {
  string fname = upfile.PostedFile.FileName;
  int fi = fname.LastIndexOf("\\") + 1;
  string filename = fname.Substring(fi);
  string path = "upload/filename";//这个就是你的图片路径
  upfile.PostedFile.SaveAs(Server.MapPath(path));
  string strSql = "insert into table(imagePath) values(@imagePath)";
  Sqlparameter[] para = {new sqlparameter("@imagePath",sqldbtype.varchar,100)};
  para[0].value=path;
  if(sqlhelper.ExecuteNonquery(strSql,para)==1)
     Response.Write("<script>alert('报名表上传成功！');</script>");
  else
     Response.Write("<script>alert('报名表上传失败！');</script>");

  }
  else
  {
  Response.Write("<script>alert('请选择您要上传的报名表！');</script>");
  }

  }

[huangwenquan123]

string path = "upload/"+filename;//这个就是你的图片路径

[int64]

"upload\\" + filename
就是文件名，把他写入数据库吗？

[huangwenquan123]

//下载
string path = Server.MapPath(dr["imagePath"]);
 FileInfo file = new FileInfo(path);
                    Response.Clear();
                    Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode((file.Name), System.Text.Encoding.UTF8));
                    Response.AddHeader("content-length", file.Length.ToString());
                    Response.ContentType = "application/octet-stream";
                    Response.WriteFile(file.FullName);
                    Response.Flush();
                    Response.Close();
                    Response.End();

[wuyq11]

protected void btnUpload_Click(object sender, EventArgs e)
{
if(fileUpload.HasFile)
{
string savePath = Server.MapPath("~/upload/");
if(!System.IO.Directory.Exists(savePath))
{
System.IO.Directory.CreateDirectory(savePath);
}
savePath = savePath + "\\" + fileUpload.FileName;
fileUpload.SaveAs(savePath); /savePath保存数据库
}
}

string fileName = "";//客户端保存的文件名
string filePath = Server.MapPath("");//路径

FileInfo fileInfo = new FileInfo(filePath);
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName);
Response.AddHeader("Content-Length", fileInfo.Length.ToString());
Response.AddHeader("Content-Transfer-Encoding", "binary");
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.WriteFile(fileInfo.FullName);
Response.Flush();
Response.End();

[newdigitime]

文件名就是
string fname="upload/"+filename;
当然,最好弄成绝对路径
如 "/upload/"+filename;