下载文件

最新推荐文章于 2025-11-26 14:12:29 发布

转载最新推荐文章于 2025-11-26 14:12:29 发布 · 425 阅读

文章标签：

#dataset #string #数据库 #byte

Asp.Net 同时被 2 个专栏收录

21 篇文章

订阅专栏

C#.NET

10 篇文章

订阅专栏

本文介绍如何从数据库读取指定ID的数据，并将其作为附件响应到客户端。

SqlConnection cn = new SqlConnection();//数据库链接 
        cn.Open();
        SqlDataAdapter da2 = new SqlDataAdapter("select   *   from   myfile   where   id=   24 ", cn);//读出数据库中相应的数据 
        DataSet ds2 = new DataSet();
        da2.Fill(ds2);
        byte[] b2 = (byte[])ds2.Tables[0].Rows[0]["files "];
        string type = (string)ds2.Tables[0].Rows[0]["type "];
        Response.Clear();
        string Type = checktype(type);
        Response.AddHeader("Content-Disposition", "attachment; filename=下载" + type);
        Response.AddHeader("Content-Length ", b2.Length.ToString());
        Response.ContentType = Type;
        Response.BinaryWrite(b2);
        Response.End();

        string FileName = ((LinkButton)sender).CommandArgument; 
        Response.Clear();
        Response.ContentType = Type;
        Response.AddHeader("Content-Disposition", "attachment;FileName= " + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8));
        Response.WriteFile(FileName);
        Response.End();