Spotted this today thanks to www.dotnet247.com...

Snippet: Inserting Serializable Objects into a Database
http://www.c-sharpcorner.com/Code/2002/April/DbComMySql.asp

I haven't done anything silly like read it, though :)

HTH,
G.


-----Original Message-----
From: dotnet discussion [mailto:[EMAIL PROTECTED]] On Behalf Of
Duncan Smart
Sent: 24 April 2002 18:33
To: [EMAIL PROTECTED]
Subject: Re: Serializing to SQL Table


Do you want to serialise the whole object to a binary field?

If so, you can serialize to a MemoryStream, then you can convert this to
a byte[] using ToArray() -- this byte[] can then be used as a Parameter
for an SQL INSERT statement (use something like command.Parameters.Add
("MyBlobField", myByteArray))

HTH,
Duncan Smart
============

On Tue, 23 Apr 2002 08:46:00 +0100, Wayne Enis <[EMAIL PROTECTED]>
wrote:

>I can successfully serialize my object to a file (binary mode), can any

>one give me any pointers for serializing to SQL2000.

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.

Reply via email to