string myOraclestr = "Data Source=" + this.textBox1.Text + ";User Id=" + this.textBox2.Text + ";Password=" + this.textBox3.Text + ";";
OracleConnection conn = new OracleConnection(myOraclestr);
OracleCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = "select r.sfzhm,p.txsj from hdds_obj_0000r010000 r,hdds_obj_0000picture p where r.zxbs is null and r.photoid is not null and r.photoid=p.serial_no";
OracleDataReader dr = cmd.ExecuteReader();
int i=0;
while (dr.Read())
{
     try
     {
          byte[] tempByte = (byte[])dr[1];
          FileStream fs = new FileStream(this.textBox4.Text + "\\" + dr[0].ToString() + ".jpg", FileMode.Create);
          fs.Write(tempByte, 0, tempByte.Length);
          fs.Close();
          Application.DoEvents();
          this.label5.Text = (i++).ToString();;
       }
       catch (Exception ex)
       {
            MessageBox.Show(ex.Message);
        }
}
dr.Close();
conn.Close();
MessageBox.Show("导出完成！！！");