Oracle中存取rtf文档

  private void button2_Click(object sender, System.EventArgs e)
  {

   //写rtf
   System.Windows.Forms.OpenFileDialog PicOpen=new OpenFileDialog();
   PicOpen.Filter="文本文件 (*.rtf)|*.rtf";
   PicOpen.Title="请选择文本";
   string filePath;
   if(DialogResult.OK==PicOpen.ShowDialog())
   {
    if((filePath=PicOpen.FileName)!= null)
    {
     //    
     PicOpen.OpenFile();
         
     //将图片导入数据库blob字段
     System.Data.OracleClient.OracleConnection lup=new OracleConnection();
     
     OracleCommand cmd=new OracleCommand();
     OracleCommand cmd2=new OracleCommand();
     lup.ConnectionString="user id=system;data source=lupgis;password=***";
     cmd.Connection=lup;
     cmd2.Connection=lup;
     try
     {     
      lup.Open();   
      cmd.CommandText="UPDATE lupuser.GHCG_W_GHWB SET ghwb=:ghwb WHERE xzmc='观音寺镇'";
      OracleParameter myParameter = cmd.Parameters.Add("ghwb",OracleType.Blob);
      myParameter.Direction = ParameterDirection.Input;
      FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read); 
      byte[] ghwb = new Byte[fs.Length];
      fs.Read(ghwb, 0, ghwb.Length);
      fs.Close();
      cmd.Parameters[0].Value=ghwb;
      cmd.ExecuteNonQuery();
      MessageBox.Show("上传成功");
      cmd2.CommandText="SELECT ghwb FROM lupuser.GHCG_W_GHWB WHERE xzmc='xx镇'";
      //OracleParameter myParameter2 = cmd2.Parameters.Add("ghwb",OracleType.Blob);
      //myParameter2.Direction = ParameterDirection.Output;
      System.Data.OracleClient.OracleDataReader dr=cmd2.ExecuteReader();
      dr.Read();
      byte[] byteData= (byte[])dr["ghwb"];
      Stream myStream=new MemoryStream();
      myStream.Write(byteData,0,byteData.Length);
      FileStream fileStream1 = new FileStream("Temp.rtf",FileMode.Create,FileAccess.Write);
      fileStream1.Write(byteData,0,byteData.Length);
      fileStream1.Close();

      this.richTextBox1.LoadFile("Temp.rtf",RichTextBoxStreamType.RichText);
      myStream.Close();

     }
     finally
     {
      lup.Close();
     }
     

 

    }

   }
  }
   
 }

posted on 2006-01-13 19:54  StinJia  阅读(698)  评论(0)    收藏  举报

导航