/// <summary>
/// Converte un file partendo dal suo path in un Array di bytes. Utile al salvataggio nel DB.
/// </summary>
/// <param name="FileName">Il percorso del File</param>
/// <param name="FileConverted">Il file convertito</param>
/// <returns>True se il file viene convertiro, False altrimenti</returns>
public static bool ConvertFileToByteArray(string FileName, out byte[] FileConverted)
{
FileConverted = null;
if(!File.Exists(FileName))
return false;
FileStream fs = null;
try
{
fs = new FileStream(FileName, FileMode.Open);
FileInfo fi = new FileInfo(FileName);
long temp = fi.Length;
int length = Convert.ToInt32(temp);
FileConverted = new byte[length];
fs.Read(FileConverted, 0, length);
fs.Close();
return true;
}
catch(Exception ex)
{
Global.Log.Write(LogSeverity.Critical, "Global", "ConvertFileToByteArray", ex.Message);
return false;
}
}"UPDATE tabella SET OLEObjectField = " + FileConverted + " WHERE... "protected void Page_Load(object sender, EventArgs e)
{
'Qui fai la connessione etc...
Response.ContentType = "Application/unknown";
Response.AddHeader("content-disposition", "attachment; filename=" + Recordset("FileName"));
Response.BinaryWrite(Recordset("OLEObjectField"));
Response.End();
}
