GetChunk equivalent in C#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have a legacy SQL Database that uses ADO and AppendChunk to store a BLOB of data in a column. It was written in C++

I am now trying to retrieve that data back using C# and a DataReader without any luck. I know it would be better to store the binary data as IMAGE but it wasn't done that way.
Any idea how I can get the BLOB preferably in a byte[] array?

TIA

John Hoffma
 
Hi

You need to use DataReader with the commandbehaviour as sequentialaccess. Check this link out

http://msdn.microsoft.com/library/d.../html/cpconobtainingblobvaluesfromdatabase.as

Hope this helps..

Regards
Madh

MVP | MCSD.NE

----- John Hoffman wrote: ----

Hello

I have a legacy SQL Database that uses ADO and AppendChunk to store a BLOB of data in a column. It was written in C++

I am now trying to retrieve that data back using C# and a DataReader without any luck. I know it would be better to store the binary data as IMAGE but it wasn't done that way.
Any idea how I can get the BLOB preferably in a byte[] array?

TIA

John Hoffma
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getchunk & Appendchunk 2
Need Help declaring parameter variables for DllImport for c-dll fu 8
Passing a memory stream to Process object? 1
MySQL & BLOB field retrieving 2
Writing BLOBs (through C#) 1
Retrieving VBA-DAO inserted Blob Data in Access via ADO.Net-C# 0
cast from "array of byte" to "array of struct" 3
Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 2

Back
Top