C # file and binary mutual transfer database write read-out

2. This method is to browse the file object
4. private void button1_click (object sender, EventArgs e)
6. {
8. //user open File Browse
10. using (OpenFileDialog Dialog = new OpenFileDialog ())
12. {
14. //Only one file can be selected
16. Dialog.  MultiSelect = false;
18. //Select a file
20. if (dialog. ShowDialog () = = DialogResult.OK)
22. {
24. Try
26. {
28. //Take the selected file path to Txtpath
30. this.textBox1.Text = dialog.  FileName;
32. }
34. catch (Exception ex)
36. {
38. //Throw exception
40. throw (ex);
42. }
44. }
46. }
48. }
52. //Off
54. private void button3_click (object sender, EventArgs e)
56. {
58. This .  Close ();
60. }
64. //Convert files into binary streams into the database
66. private void button2_click (object sender, EventArgs e)
68. {
70. FileStream fs = new FileStream (TextBox1.Text, FileMode.Open);
72. BinaryReader br = new BinaryReader (FS);
74. byte[] Bydata = br. Readbytes ((int) fs.  Length);
76. Fs. Close ();
78. String conn = "server=.; Database=testdb; Uid=sa;  Pwd=sa ";
80. SqlConnection myconn = new SqlConnection (conn);
82. MyConn. Open ();
84. string str = "INSERT into pro_table (pro_name,pro_file) VALUES (' Test file ', @file)";
86. SqlCommand Mycomm = new SqlCommand (str, myconn);
88. Mycomm.  Parameters.Add ("@file", Sqldbtype.binary, Bydata.length);
90. Mycomm. parameters["@file"].  Value = Bydata;
92. Mycomm. ExecuteNonQuery ();
94. MyConn. Close ();
96. }
100. //From the database to read the binary stream to write to restore the file
102. private void button4_click (object sender, EventArgs e)
104. {
106. String conn = "server=.; Database=testdb; Uid=sa;  Pwd=sa ";
108. string str = "Select Pro_file from pro_table where pro_name= ' test file '";
110. SqlConnection myconn = new SqlConnection (conn);
112. SqlDataAdapter SDA = New SqlDataAdapter (STR, conn);
114. DataSet myds = new DataSet ();
116. MyConn. Open ();
118. Sda. Fill (myds);
120. MyConn. Close ();
122. Byte[] Files = (byte[]) myds. Tables[0].   rows[0]["Pro_file"];
124. BinaryWriter bw = new BinaryWriter (File.Open ("D:\\2.RDLC", FileMode.OpenOrCreate));
126. Bw. Write (Files);
128. Bw. Close ();
132. }

This is the project to resolve the report rdlc into the database once again read out the Restore method (after testing to any file on the valid [audio files, compressed packages, Word documents, etc.])

Someone here might ask that RDLC is XML, why not just manipulate XML storage? In our project, it is possible to have the RDLC format with pictures in the RDLC, so we simply make a direct binary streaming process.