int PictureCol = 0;
OleDbConnection conn = new OleDbConnection("Provider=MSDAORA;Data Source=127.0.0.1;User ID=---;Password = ---");
OleDbCommand myCommand = new OleDbCommand("select photobrowse from mpho where username = 'tmac'",conn);
conn.Open();
OleDbDataReader dr = myCommand.ExecuteReader();
dr.Read();
Byte[] b = new Byte[(dr.GetBytes(PictureCol, 0, null, 0, int.MaxValue))];
dr.GetBytes(PictureCol, 0, b, 0, b.Length);
dr.Close();
conn.Close();
string DestFilePath = @"C:\lena2.bmp";
System.IO.FileStream fs = new System.IO.FileStream(DestFilePath, System.IO.FileMode.Create, System.IO.FileAccess.Write);
fs.Write(b, 0, b.Length);
fs.Close();