string query = "SELECT cast(memofieldname as blob)as memofieldname FROM ...";The result should give the file contents as is
>String fileName; >fileName = Path.Combine(System.IO.Path.GetTempPath(), > "Samplefile.jpg"); > >if (System.IO.File.Exists(fileName) == true) > { > System.IO.File.Delete(fileName); > } > >FileStream oFs = new > FileStream(fileName, FileMode.CreateNew, FileAccess.ReadWrite); > >StreamWriter oWriter = new StreamWriter(oFs); > >ASCIIEncoding asciiEncoding = new ASCIIEncoding(); >oWriter.Write(asciiEncoding.GetBytes(reminderMainRow.reFile)); //That is the memo field. >oWriter.Flush(); >oWriter.Close(); >oFs.Close(); >