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.