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();
}
}
}
}
}
浙公网安备 33010602011771号