过路的帮俺看看,路过有分
我数据库字段 "多附件上传地址 " 中形式如下:
A:/aaa;B:/bbb;C:/ccc;
下载的时候怎么办?
public string FormatString(string str)
{
str = str.Replace( " ", " ");
str = str.Replace( " < ", "< ");
str = str.Replace( "> ", "> ");
str = str.Replace( '\n '.ToString(), " <br> ");
return str;
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Request[ "id "] != null)
{
int id = Convert.ToInt32(Request[ "id "]);//转换为数字,防止sql注入
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ "SQLCONNECTIONSTRING "].ConnectionString);
conn.Open();
adr = "select 附件上传地址 from Mail WHERE 邮件编号 = " + id;
SqlCommand cmd = new SqlCommand(adr, conn);
string path = cmd.ExecuteScalar().ToString();
//取得路径
filepath = FormatString(path.ToString()).ToString().Trim();
string Temp_filename = FormatString(path.ToString()).ToString();
int pos = Temp_filename.LastIndexOf( "\\ ") + 1;
filename = Temp_filename.Substring(pos, Temp_filename.Length - pos).ToString();
filename = HttpUtility.UrlEncode(System.Text.Encoding.UTF8.GetBytes(filename));
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
FileStream fs = new FileStream(filepath, FileMode.Open);