这篇文章主要介绍了C#实现文件与二进制互转并存入数据库,本文直接给出代码实例,代码中包含详细注释,需要的朋友可以参考下
//这个方法是浏览文件对象privatevoidbutton1_Click(objectsender, EventArgs e){//用户打开文件浏览using(OpenFileDialog dialog =newOpenFileDialog()){//只能单选一个文件dialog.Multiselect =false;//选择一个文件if(dialog.ShowDialog() == DialogResult.OK){try{//把选择的文件路径给txtPaththis.textBox1.Text = dialog.FileName;}catch(Exception ex){//抛出异常throw(ex);}}}}//关闭privatevoidbutton3_Click(objectsender, EventArgs e){this.Close();}//把文件转成二进制流出入数据库privatevoidbutton2_Click(objectsender, EventArgs e){FileStream fs =newFileStream(textBox1.Text, FileMode.Open);BinaryReader br =newBinaryReader(fs);Byte[] byData = br.ReadBytes((int)fs.Length);fs.Close();stringconn ="server=.;database=testDB;Uid=sa;Pwd=sa ";SqlConnection myconn =newSqlConnection(conn);myconn.Open();stringstr ="insert into pro_table (pro_name,pro_file) values('测试文件',@file)";SqlCommand mycomm =newSqlCommand(str, myconn);mycomm.Parameters.Add("@file", SqlDbType.Binary, byData.Length);mycomm.Parameters["@file"].Value = byData;mycomm.ExecuteNonQuery();myconn.Close();}//从数据库中把二进制流读出写入还原成文件privatevoidbutton4_Click(objectsender, EventArgs e){stringconn ="server=.;database=testDB;Uid=sa;Pwd=sa ";stringstr ="select pro_file from pro_table where pro_name='测试文件' ";SqlConnection myconn =newSqlConnection(conn);SqlDataAdapter sda =newSqlDataAdapter(str, conn);DataSet myds =newDataSet();myconn.Open();sda.Fill(myds);myconn.Close();Byte[] Files = (Byte[])myds.Tables[0].Rows[0]["pro_file"];BinaryWriter bw =newBinaryWriter(File.Open("D:\\2.rdlc",FileMode.OpenOrCreate));bw.Write(Files);bw.Close();}
