使用带有保存文件提示的FileStream保存文件，使用sql server [英] saving file with FileStream with save file prompt, using sql server

问题描述

我试图从sql server数据库表字段中保存文件是（FileID，FileName，ContentType，FileData）并且似乎无法使用FileStream而不指定本地路径。



这是我检索文件的方法，但它需要一个本地路径而不是IIS ...

Im trying to save a file from sql server database table fields are(FileID, FileName, ContentType, FileData) and cant seem to use FileStream without specifying a local path.

this is my method to retrieve the file, but it requires a local path not IIS...

private void Download(DataTable dt)
    {
        Byte[] bytes = (Byte[])dt.Rows[0]["FileData"];
        string fileName = dt.Rows[0]["FileName"].ToString();
        
        FileStream fs =
            new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write);

        BinaryWriter bw = new BinaryWriter(fs);       
        
        bw.Write(bytes, 0, bytes.Length);
        bw.Close();
        bw.Flush();
        
        fs.Close();

        Response.ClearContent();
        Response.Clear();
        Response.ContentType = dt.Rows[0]["ContentType"].ToString();
        Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
        Response.TransmitFile(fileName);
        Response.Write(fs);

        Response.Flush();
        Response.End();

任何帮助都将不胜感激。谢谢！

Any help would be greatly appreciated.Thanks in advance!

推荐答案

Byte[] bytes = (Byte[])dt.Rows[0]["FileData"];
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = dt.Rows[0]["ContentType"].ToString();
Response.AddHeader("content-disposition", "attachment;filename="
                + dt.Rows[0]["FileName"].ToString());
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();

这篇关于使用带有保存文件提示的FileStream保存文件，使用sql server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！