Dataset + Storing SQL datatype Image

[mike55]

I am using crystal reports and using the push method to provide the data to the crystal report from a dataset. Everything is working correctly, in that I am getting back the data and displaying it in my report. The one think that I am having problems with is the sql image type. How can I represent this in an vb.net dataset table, i.e. what is the corresponding datatype System.X?

Mike55.

 

[PlausiblyDamp]

Not 100% on this but a Byte array is probably the easiest way to represent them.

 

[mike55]

Yea, thats what I used in the end. When I drag my picture field on my report, it does not display any of the data that exists in the database table. I have tried to insert a picture object and link that to my dataset field but no luck. I managed to do this before using an IBlobField, the problem now is that I cant remember how I did it.

Mike55.