二进制流数据保存问题
请问，我现在可以实现将数据库中的二进制流图片读取后显示在IE上，但是如何将其作为一个文件保存到本地硬盘呢？我的代码如下，请高手指点如何修改，万分感谢！

C# code

protected void Button2_Click(object sender, EventArgs e)    {        //建立数据库链接        SqlConnection Con = new SqlConnection();        Con.ConnectionString = "Data Source=5C4B31A8922E479\\WZ;" + "Database=KGEManage;" + "Integrated Security=True";        String SqlCmd = "SELECT * FROM ImageStore WHERE ImageID = 5";        SqlCommand CmdObj = new SqlCommand(SqlCmd, Con);        Con.Open();        SqlDataReader SqlReader = CmdObj.ExecuteReader();        SqlReader.Read();        Response.ContentType = (string)SqlReader["ImageContentType"];//设定输出文件类型         //输出图象文件二进制数制         Response.OutputStream.Write((byte[])SqlReader["ImageData"], 0, (int)SqlReader["ImageSize"]);        Response.End();        Con.Close();                }

这个是针对图片文件，那如果我是其他的文件，比如doc文件，是否可以用相同方法实现二进制流的存储于读取？

[解决办法]

C# code

  //获取二进制数据流        Stream data = File.Open(Server.MapPath(@"~/binary/c.doc"), FileMode.Open);        BinaryReader reader = new BinaryReader(data);        byte[] bytes = new byte[data.Length];        reader.Read(bytes, 0, bytes.Length);        data.Close();        reader.Close();        //        Response.Clear();        Response.ContentType = "application/msword";        Response.BinaryWrite(bytes);
[解决办法]
C# code
protected void Button2_Click(object sender, EventArgs e)    {        //建立数据库链接        using(SqlConnection Con = new SqlConnection())        {            Con.ConnectionString = "Data Source=5C4B31A8922E479\\WZ;" + "Database=KGEManage;" + "Integrated Security=True";            String SqlCmd = "SELECT * FROM ImageStore WHERE ImageID = 5";            SqlCommand CmdObj = new SqlCommand(SqlCmd, Con);            Con.Open();            SqlDataReader SqlReader = CmdObj.ExecuteReader();            SqlReader.Read();                        //Response.ContentType = (string)SqlReader["ImageContentType"];//设定输出文件类型            ////输出图象文件二进制数制            // Response.OutputStream.Write((byte[])SqlReader["ImageData"], 0, (int)SqlReader["ImageSize"]);                        /**/            byte[] bytes = (byte[])SqlReader["ImageData"];                                    using(FileStream fs = File.Create(Server.MapPath("~/file.jpg")))            {                fs.Write(bytes,0,bytes.Length);            }            /**/                        Con.Close();        }    }
[解决办法]
C# code
 FileStream fileStream = new FileStream(filePath, FileMode.Open);                long fileSize = fileStream.Length;                bytes = new byte[(int)fileSize];                fileStream.Read(bytes, 0, (int)fileSize);                fileStream.Close();                Response.Clear();                Response.BinaryWrite(bytes);                Response.End();
[解决办法]
doc最好保存服务器硬盘上，不要往数据库里存储，二进流很容易产生格式错误，如果必须存数据库的话输出和输入最好转化成字符串格式用ntext字段保存