how to work with large Text and ADO.NET?

[George Ter-Saakov]

I need to be able to log large requests.
Data type TEXT in MS SQL.

How do I insert record with that field?

My understanding that if the text is larger than 8000 characters then I have
to work with it differently.
Am I correct?


Thanks.
George.

 

[Jacob Yang [MSFT]]

Hi George,

As I understand, what you really want to know is how to handle very large
data in ADO.NET/SQL/ASP.NET.

Based on my research and experience, I believe that the following article
is useful to you. Please refer to it carefully.

HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;326502
"...
This article describes how to use the FileStream object and a byte array in
ASP.NET to write binary large object (BLOB) data to Microsoft SQL Server.
This article also describes how to load BLOB data from the SQL Server
database and how to copy this data to a downloadable file through the .aspx
page.
..."

Does it answer your question? If I have misunderstood your concern, please
feel free to let me know.

Best regards,

Jacob Yang
Microsoft Online Partner Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.