How to load a file into notepad without first loading into RAM?

Question

I am using C # and I am having problems loading large files into a binary field using byte arrays.

Basically, if I upload a file that is too large, I am having memory problems.

Is there a way to load a file into a binary field without using large amounts of memory, i.e. Do not load the file into memory first?

If this helps, I use Advantage Database Server and this winforms application is not a web application.

Hi

Answer 1

AdsExtendedReader.SetBytes . AdsSetBinary(), .

. AdsExtendedReader.SetBytes.

Answer 2

Advantage (ACE) API AdsSetBinary blob . , , . #:

[DllImport("ace32.dll", CharSet=CharSet.Ansi, CallingConvention=CallingConvention.Winapi )]
              public static extern uint AdsSetBinary( IntPtr hTable, String pucFldName, ushort usBinaryType, uint ulTotalLength, uint ulOffset, byte[] pucBuf, uint ulLen );   

API C:

http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.1/mergedProjects/ace/api2/adssetbinary.htm

API, . AdsExtendedReader.AdsHandle.

: Alex, , , , AdsSetBinary .NET-. , .:)

Answer 3

, , , id , x .

Answer 4

"UPDATE.WRITE". . .WRITE : http://msdn.microsoft.com/en-us/library/ms177523.aspx.

Unfortunately, this is for SQL Server. I think the Advantage Database Server will be a little different here, but maybe this will send you in the right direction.