Oracle读写数据库图片

        一、写入
        string file_name = Server.MapPath(@"20080523.jpg");
        string conn_str = "Provider=OraOLEDB.Oracle.1;Password=base;Persist Security Info=True;User ID=base;Data Source=orcl;Extended Properties=";//Provider必須用OraOLEDB.Oracle.1
        OleDbConnection cn = new OleDbConnection(conn_str);
        cn.Open();
        OleDbCommand cmd = new OleDbCommand("UPDATE BLOB SET PHOTO = ? ",cn);
        cmd.Parameters.Add("PHOTO",OleDbType.Binary);
        FileStream fs = new FileStream(file_name, FileMode.OpenOrCreate, FileAccess.Read);
        byte[] MyData= new byte[fs.Length];
        fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
        fs.Close();
        cmd.Parameters["PHOTO"].Value = MyData;
        try
        {
            int result = cmd.ExecuteNonQuery();
            if(result<1)
            {
                OleDbCommand cmd1 = new OleDbCommand(" INSERT INTO BLOB (PHOTO) VALUES ( ? )",cn);
                cmd1.Parameters.Add("PHOTO",OleDbType.Binary);
                cmd1.Parameters["PHOTO"].Value = MyData;
                result = cmd1.ExecuteNonQuery();
            }
        }
        catch(Exception e1)
        {
            Page.RegisterStartupScript("","<script language='javascript'>alert('"+e1.Message+"')</script>");
        }
        finally
        {
            cn.Close();
        }
二、读取
        string conn_str = "Provider=OraOLEDB.Oracle.1;Password=base;Persist Security Info=True;User ID=base;Data Source=orcl;Extended Properties=";//Provider必須用OraOLEDB.Oracle.1
        DataSet ds = new DataSet();
        OleDbConnection conn = new OleDbConnection(conn_str);
        OleDbCommand cmd = new OleDbCommand("SELECT PHOTO FROM BLOB", conn);
        OleDbDataAdapter da = new OleDbDataAdapter();
        da.SelectCommand = cmd;
        cmd.Connection.Open();
        da.Fill(ds);
        byte[] img = new byte[0];
        DataRow dr;
        dr = ds.Tables[0].Rows[0]; if (!ds.Tables[0].Rows[0]["PHOTO"].ToString().Equals(""))
        {
            img = (byte[])dr["PHOTO"];
        }
        Response.ContentType = "image/*";
        Response.BinaryWrite(img);
        conn.Close();