C# 操作数据库写入、读取二进制文件

[dream__life]

protected void Button1_Click(object sender, EventArgs e)
    {
        //写入
        string path = this.FileUpload1.PostedFile.FileName;
        FileStream stream = new FileStream(path, FileMode.Open, FileAccess.Read);

        int length = this.FileUpload1.PostedFile.ContentLength;
        byte[] wordData = new byte[length];
        stream.Read(wordData, 0, length);
        stream.Close();
        
        SqlConnection con = new SqlConnection(connectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("insert into word values('test','" + wordData + "')", con);
        cmd.ExecuteNonQuery();
        con.Close();

    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        //读取
        SqlConnection con = new SqlConnection(connectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("select content from word where id=9", con);
        SqlDataReader sdr = cmd.ExecuteReader();

        FileStream fs;
        BinaryWriter bw;

         byte[] outbyte = null;

        string filePath = @"D:\word.doc";

        while (sdr.Read())
        {
            fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write);
            bw = new BinaryWriter(fs);

            outbyte=(byte[])sdr["content"];
            bw.Write(outbyte, 0, outbyte.Length);
            
            bw.Flush();
            bw.Close();
            fs.Close();
        }
        sdr.Close();
        con.Close();
    }

我用来将WORD文档写入数据库，再读取到指定目录下。
但是无法读取出来，程序运行后，打开文档，内容只有“System.Byte[]”。
在线等，我要疯了……

[jackyoung02]

是这句有问题：

byte[] outbyte = null;

改成如下试试看：


byte[] outbyte = new byte[(int)sdr["content"].ToString().Length];

[cpio]

string path = this.FileUpload1.PostedFile.FileName;
FileStream stream = new FileStream(path, FileMode.Open, FileAccess.Read);

你要知道FileUpload1.PostedFile.FileName表示用户的文件路径

FileUpload1.PostedFile.InputStream，或者FileUpload1.FileContent 表示内容(Stream)

也可以直接用FileUpload1.FileBytes

[songhuan]

这有错误
SqlCommand cmd = new SqlCommand("insert into word values('test','" + wordData + "')", con);


改成这样

SqlCommand cmd = new SqlCommand("insert into word values('test',@wordData )", con);
cmd.Parameters.Add("@wordData ", wordData )

[dream__life]

不行啊，生成的WORD中只有“System.Byte[]”这个内容。

[dream__life]

[Quote=引用 3 楼 songhuan 的回复:]
这有错误
SqlCommand cmd = new SqlCommand("insert into word values('test','" + wordData + "')", con);


改成这样

SqlCommand cmd = new SqlCommand("insert into word values('test',@wordData )", con);
cmd.Parameters.Add("@wordData ", wordData )
[/Quote]

Thank You!!! OK了！
不过存入的英文文档可以正常读取，但是中文的WORD文档，读取出来之后就是乱码了……
郁闷中