using System.IO;

StreamWriter sw=File.CreateText("c://text.txt");  sw.WriteLine("C#");                //寫入一行文本 sw.Write("www.csdn.net");             //在文本末尾寫入文本 sw.Flush();                    //清空 sw.Close();                    //關閉 

StreamReader sr = File.OpenText("c://text.txt"); sr.ReadLine();                  //讀取一行數(shù)據(jù) sr.Read();                    //讀取一個字符 sr.ReadToEnd();                  //從當前位置讀取到文本結束 sr.Close();                    //釋放資源 

StreamWriter sw = File.AppendText("c://text.txt"); sw.WriteLine("C#");                 //寫入一行文本 sw.Write("www.csdn.net");              //在文本末尾寫入文本 sw.Flush();                     //清空 sw.Close();                     //關閉 

File.Exists("c://text.txt"); 

File.Delete("c://text.txt"); 

File.Copy("c://text.txt", "c://copy.txt");   //把c://text.txt復制到c://copy.txt 

File.Copy("c://text.txt", "d://text.txt");  //把c://text.txt移動到d://text.txt 

Directory.Delete("c://test");       //刪除C盤下的test文件夾 Directory.CreateDirectory("c://test");  //在C盤創(chuàng)建test文件夾 Directory.Exists("c://test");       //驗證C盤test文件夾是否存在 Directory.Move("c://test", "d://test");  //把c:/test移動到d:/test 

create table tb_file (  id       number(20) not null,  file_name    nvarchar2(100),  file_content  blob,  constraint pk_tb_file primary key (id) ) tablespace mydb storage(  initial 64K  minextents 1  maxextents unlimited ); 

create sequence seq_tb_file  --創(chuàng)建自增序列 minvalue 1 maxvalue 9999999999999999999 start with 1 increment by 1 nocache order;  create or replace trigger ai_tb_file --創(chuàng)建觸發(fā)器，當插入新記錄時自增主鍵id before insert on tb_file for each row when (new.id is null) begin select seq_tb_file.nextval into :new.id from dual; end; 

//添加命名空間 using System; using System.Data.OracleClient; using System.IO; using System.Data;  /// <summary> /// 把文件插入數(shù)據(jù)庫中 /// </summary> /// <param name="filePath">文件名，包含路徑，如c:/temp.rar</param> /// <returns></returns> public int Insert(string filePath) {   string connStr = "data source=orcl;user=mydbuser;password=mydbuser;";   OracleConnection conn = new OracleConnection(connStr);   OracleCommand cmd = conn.CreateCommand();    //讀取文件   FileStream fs = File.OpenRead(filePath);   byte[] buffer = new byte[fs.Length];   fs.Read(buffer, 0, buffer.Length);    OracleParameter paramFileContent = cmd.CreateParameter();   paramFileContent.OracleType = OracleType.Blob;   paramFileContent.ParameterName = "FileContent";   paramFileContent.Direction = ParameterDirection.Input;   paramFileContent.Value = buffer;   cmd.Parameters.Add(paramFileContent);    OracleParameter paramFileName = cmd.CreateParameter();   paramFileName.OracleType = OracleType.VarChar;   paramFileName.ParameterName = "FileName";   paramFileName.Direction = ParameterDirection.Input;   paramFileName.Value = Path.GetFileName(filePath);   cmd.Parameters.Add(paramFileName);    string sqlInsert = "insert into tb_file (file_name, file_content) values (:FileName, :FileContent)";   cmd.CommandText = sqlInsert;   cmd.CommandType = CommandType.Text;    conn.Open();   int result = cmd.ExecuteNonQuery();   conn.Close();    return result; }   /// <summary> /// 根據(jù)文件名從數(shù)據(jù)庫中獲取文件 /// </summary> /// <param name="fileName">數(shù)據(jù)庫中的文件名</param> /// <param name="savePath">文件的保存路徑，包括文件名，如c:/file.rar</param> public void Select(string fileName, string savePath) {   string connStr = "data source=orcl;user=mydbuser;password=mydbuser;";   OracleConnection conn = new OracleConnection(connStr);   OracleCommand cmd = conn.CreateCommand();    string sqlSelect = "select file_name, file_content from tb_file where file_name=:FileName";   cmd.CommandText = sqlSelect;   cmd.CommandType = CommandType.Text;    OracleParameter paramFileName = cmd.CreateParameter();   paramFileName.OracleType = OracleType.VarChar;   paramFileName.ParameterName = "FileName";   paramFileName.Direction = ParameterDirection.Input;   paramFileName.Value = fileName;   cmd.Parameters.Add(paramFileName);          conn.Open();   OracleDataReader dr = cmd.ExecuteReader();   dr.Read();   byte[] buffer = (byte[])dr["file_content"];   dr.Close();   conn.Close();    //把文件保存到指定路徑   File.WriteAllBytes(savePath, buffer); }