C# 讀取和寫入oracle的blob字段的方法

2019-11-17 04:05:46

字體：大中小

來源：轉載

供稿：網友

//向數據庫中寫入

        PRivate void button1_Click(object sender, EventArgs e)

        {

            OracleConnection1.Open();



            OracleCommand cmd = new OracleCommand("UPDATE TEST SET F2 =:blob where F1=:sn ", oracleConnection1);



            cmd.Parameters.Add(new OracleParameter("blob",OracleType.Blob));

              cmd.Parameters.Add(new OracleParameter("sn",OracleType.Int32));

             FileInfo fi = new FileInfo("c://dos.doc");

             FileStream fs = fi.OpenRead();

             byte[] MyData = new byte[fs.Length];

             fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));

             fs.Close();

            cmd.Parameters["blob"].Value = MyData;

            cmd.Parameters["sn"].Value = 1;

            try

            {

                int result = cmd.ExecuteNonQuery();

                if (result < 1)

                {

                    System.Console.WriteLine("插入數據錯誤！");

                }

                else

                    System.Console.WriteLine("插入數據成功！");

            }

            catch (Exception e1)

            {

                System.Console.WriteLine("插入數據錯誤！"+e1.ToString());

            }

            finally

            {

                oracleConnection1.Close();

            }

        }

//從數據庫中讀取

        private void button2_Click(object sender, EventArgs e)

        {

            oracleConnection1.Open();

            oracleCommand1.CommandText = "select * from TEST where f1=1";

            OracleDataReader rs = oracleCommand1.ExecuteReader();

            while (rs.Read())//讀取數據，如果odr.Read()返回為false的話，就說明到記錄集的尾部了

            {

                byte[] File=(byte[])rs["F2"];

                   FileInfo fi=new FileInfo("c://new.doc");

                   FileStream fs=fi.OpenWrite();

                   fs.Write(File,0,File.Length);

                   fs.Flush();

                fs.Close();



            }

            rs.Close();

        }

上一篇：C#中調用VB中Inputbox功能

下一篇：Ajax產品浪潮現身市場：成就未來SOA