//这个方法是浏览文件对象

        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[].Rows[]["pro_file"];

            BinaryWriter bw = new BinaryWriter(File.Open("D:\\2.rdlc",FileMode.OpenOrCreate));

            bw.Write(Files);

            bw.Close();

        }