Exporter des photos en local

Bon j'ai fini par trouver une solution :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
........
OracleLob myPicture = reader.GetOracleLob(2);
 
String filePicture = dossier + "\\" + file_name + "." + file_suffix;
 
// fetch the value of Oracle parameter into the byte array
byteData = (byte[])(myPicture.Value);
 
// get the length of the byte array
int ArraySize = new int();
ArraySize = byteData.GetUpperBound(0);
 
// Write the Blob data fetched from database to the filesystem at the
// destination location
FileStream fs1 = new FileStream(@filePicture,FileMode.OpenOrCreate, FileAccess.Write);
fs1.Write(byteData, 0, ArraySize);
fs1.Close();

il y a peu être mieux ... mais cela fonctionne