ASP.net怎么打开数据库中以二进制存贮的WORD文档或别的文档?

[wss1801]

我把文件以二进制的形式放到数据库中,现在我要怎么打开这个文件呀?

[wss1801]

能给个例子不？

[namhyuk]

string strCnn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
SqlConnection myConnection = new SqlConnection(strCnn);
SqlCommand command = new SqlCommand("select 附件, 附件名称, 附件类型 from 表名 Where NewsID =" + Request.QueryString["id"], myConnection);
myConnection.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
      Response.Clear();
      Response.HeaderEncoding = System.Text.Encoding.GetEncoding("GB2312"); 
      //Response.Charset = "UTF-8";
      Response.AddHeader("Content-Type", dr["附件类型"].ToString()); // File Upload时存到数据库的
      Response.AppendHeader("TITLE", dr["附件名称"].ToString());
      //Response.AppendHeader("Content-Disposition", "inline;filename=\"" + dr["AttachmentName"].ToString() + "\"");
      string fileName = dr["附件名称"].ToString();
      Response.AppendHeader("Content-Disposition", "inline;filename=\"" + dr["AttachmentName"].ToString() + "\"");
      Response.BinaryWrite((byte[])dr["附件"]);
}
dr.Close();
myConnection.Dispose();

[namhyuk]

string strCnn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
SqlConnection myConnection = new SqlConnection(strCnn);
SqlCommand command = new SqlCommand("select 附件, 附件名称, 附件类型 from 表名 Where NewsID =" + Request.QueryString["id"], myConnection);
myConnection.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
      Response.Clear();
      
      Response.HeaderEncoding = System.Text.Encoding.GetEncoding("GB2312"); 
      
      Response.AddHeader("Content-Type", dr["附件类型"].ToString()); // File Upload时存到数据库的

       Response.AppendHeader("TITLE", dr["附件名称"].ToString());
     
      Response.AppendHeader("Content-Disposition", "inline;filename=\"" + dr["附件名称"].ToString() + "\"");

      Response.BinaryWrite((byte[])dr["附件"]);
}
dr.Close();
myConnection.Dispose();

[wss1801]

但是打开的是空的，名字也成乱码了？

[sxmonsy]

编码改下试试: Response.HeaderEncoding = System.Text.Encoding.GetEncoding("GB2312");
把GB2312 改成别的.

[wss1801]

当我是图片格式的时候就不行
？

[wss1801]

word文档是可以打开的，大家说说怎么回事？

[wss1801]

?

[walkghost]

编码用utf8

[wss1801]

试过了，还是不行

[wss1801]

我打开图片格式就是乱码？谢谢！

[zld_baggio]

[Quote=引用 7 楼 yagebu1983 的回复:]
读数据库！！！
以流的形式！！！
[/Quote]

[wss1801]

晕哦

[s208ping]

string strCnn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
SqlConnection myConnection = new SqlConnection(strCnn);
SqlCommand command = new SqlCommand("select 附件, 附件名称, 附件类型 from 表名 Where NewsID =" + Request.QueryString["id"], myConnection);
myConnection.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
      Response.Clear();
      
      Response.HeaderEncoding = System.Text.Encoding.GetEncoding("GB2312"); 
      
      Response.AddHeader("Content-Type", dr["附件类型"].ToString()); // File Upload时存到数据库的

       Response.AppendHeader("TITLE", dr["附件名称"].ToString());
     
      Response.AppendHeader("Content-Disposition", "inline;filename=\"" + dr["附件名称"].ToString() + "\"");

      Response.BinaryWrite((byte[])dr["附件"]);
}
dr.Close();
myConnection.Dispose();

这个可以

[wss1801]

这个和１１楼的是一样的呀，我试了DOC,JPG可以打开，但试TIF,XLS不能打开！

[Lakers_24号程序员]

[Quote=引用 15 楼 wss1801 的回复:]
word文档是可以打开的，大家说说怎么回事？
[/Quote]

那可能是因为你指定了绝对文件格式，昨天你的贴子都发了现在还没解决？晕了！

[wss1801]

tif打开是乱码，xls文件要下载下来才能打开，不能在IE上打开？

[wss1801]

哎小弟不才呀

[JeffChung]

[Quote=引用 7 楼 yagebu1983 的回复:]
读数据库！！！
以流的形式！！！
[/Quote]

[GeorgeSky]

这个受制于客户浏览器的设置！不能直接打开啊～