Question

C# 如何将Byte[]类型存入数据库类型为nvarchar(max)的字段中

Answer 1

//把文件转成二进制流出入数据库private void button2_Click(object sender, EventArgs e){ FileStream fs = new FileStream(textBox1.Text, FileMode.Open); BinaryReader br = new BinaryReader(fs); Byte[] byData = br.ReadBytes((int)fs.Length); fs.Close(); string conn = "server=.;database=testDB;Uid=sa;Pwd=sa "; SqlConnection myconn = new SqlConnection(conn); myconn.Open(); string str = "insert into pro_table (pro_name,pro_file) values('测试文件',@file)"; SqlCommand mycomm = new SqlCommand(str, myconn); mycomm.Parameters.Add("@file", SqlDbType.Binary, byData.Length); mycomm.Parameters["@file"].Value = byData; mycomm.ExecuteNonQuery(); myconn.Close();}//从数据库中把二进制流读出写入还原成文件private void button4_Click(object sender, EventArgs e){ string conn = "server=.;database=testDB;Uid=sa;Pwd=sa "; string str = "select pro_file from pro_table where pro_name='测试文件' "; SqlConnection myconn = new SqlConnection(conn); SqlDataAdapter sda = new SqlDataAdapter(str, conn); DataSet myds = new DataSet(); myconn.Open(); sda.Fill(myds); myconn.Close(); Byte[] Files = (Byte[])myds.Tables[0].Rows[0]["pro_file"]; BinaryWriter bw = new BinaryWriter(File.Open("D:\\2.rdlc",FileMode.OpenOrCreate)); bw.Write(Files); bw.Close(); }

Answer 2

最好别这样。实在要的话，用base64编码转换一下可以存。

追问

这样存进去是乱码，

追答

存byte本来就是乱码。纯文本才是可见的。

追问

哦，谢谢