Home All Groups Group Topic Archive Search About

serialize object to MSDE binary datatype

Author
15 Dec 2006 3:07 AM
Matt Fielder
I need to find a way of serializing an object to a field in an msde table.
What I'm serializing is a report definition of a 3rd party report generator.
It's normally stored as a file on the local file system (has built in
functionality to handle), but that's not an option for what I need.  I'm
familiar with using a filestream to serialize and deserialize images to the
table, but this obviously isn't an image --- any help would be greatly
appreciated.

Author
15 Dec 2006 5:49 AM
Kevin Yu [MSFT]
Hi Matt,

To serialize the object to a byte array, the object class must be marked
with SerializableAttribute. So that we can use the BinaryFormatter to
serialize it to the array and save it to database.

Kevin Yu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Author
15 Dec 2006 5:50 AM
Cor Ligthert [MVP]
Matt,

The way an image is serialized can be used in fact with any object.
You can as well however use often the binaryformater.

http://www.vb-tips.com/dbpages.aspx?ID=7ffd296f-9e81-47e6-88dc-61641f5c8d9d

There are also more samples how to make a blob (image type(

I hope this helps,

Cor



Show quoteHide quote
"Matt Fielder" <mfielderREMOVECAPS@nospam.nospam> schreef in bericht
news:ecqCtY$HHHA.1264@TK2MSFTNGP03.phx.gbl...
>I need to find a way of serializing an object to a field in an msde table.
>What I'm serializing is a report definition of a 3rd party report
>generator. It's normally stored as a file on the local file system (has
>built in functionality to handle), but that's not an option for what I
>need.  I'm familiar with using a filestream to serialize and deserialize
>images to the table, but this obviously isn't an image --- any help would
>be greatly appreciated.
>
Author
15 Dec 2006 2:54 PM
Matt Fielder
Cor, That gets me going in the right direction - thanks, I appreciate it.

Show quoteHide quote
"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:uI8I0yAIHHA.4688@TK2MSFTNGP04.phx.gbl...
> Matt,
>
> The way an image is serialized can be used in fact with any object.
> You can as well however use often the binaryformater.
>
> http://www.vb-tips.com/dbpages.aspx?ID=7ffd296f-9e81-47e6-88dc-61641f5c8d9d
>
> There are also more samples how to make a blob (image type(
>
> I hope this helps,
>
> Cor
>
>
>
> "Matt Fielder" <mfielderREMOVECAPS@nospam.nospam> schreef in bericht
> news:ecqCtY$HHHA.1264@TK2MSFTNGP03.phx.gbl...
>>I need to find a way of serializing an object to a field in an msde table.
>>What I'm serializing is a report definition of a 3rd party report
>>generator. It's normally stored as a file on the local file system (has
>>built in functionality to handle), but that's not an option for what I
>>need.  I'm familiar with using a filestream to serialize and deserialize
>>images to the table, but this obviously isn't an image --- any help would
>>be greatly appreciated.
>>
>
>