- //这个方法是浏览文件对象
- private void button1_Click(object sender, EventArgs e)
- {
- //用户打开文件浏览
- using (OpenFileDialog dialog = new OpenFileDialog())
- {
- //只能单选一个文件
- dialog.Multiselect = false;
- //选择一个文件
- if (dialog.ShowDialog() == DialogResult.OK)
- {
- try
- {
- //把选择的文件路径给txtPath
- this.textBox1.Text = dialog.FileName;
- }
- catch (Exception ex)
- {
- //抛出异常
- throw (ex);
- }
- }
- }
- }
- //关闭
- private void button3_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- //把文件转成二进制流出入数据库
- 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();
- }
这个是项目中解决把报表rdlc存入数据库后再次读出还原出来的方法（经过测试 对任何文件对有效[音频文件，压缩包，word文档等]）
这里可能有人会问rdlc是xml的为什么不直接操作XML的存储呢？主要是我们项目中rdlc中可能有带有图片的rdlc格式 所以索性就直接二进制流化处理了。