Re: [DOTNET] Serializing to SQL Table

2002-04-25 Thread Wayne Enis
Thanks for the link, i'll take a look ! Wayne -Original Message- From: dotnet discussion [mailto:[EMAIL PROTECTED]]On Behalf Of Graeme Foster Sent: 24 April 2002 22:18 To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Serializing to SQL Table Spotted this today thanks to www.dotnet24

Re: [DOTNET] Serializing to SQL Table

2002-04-25 Thread Wayne Enis
a problem there. I'll try again with a simple test, without going through our data stuff... Thanks Wayne -Original Message- From: dotnet discussion [mailto:[EMAIL PROTECTED]]On Behalf Of Duncan Smart Sent: 24 April 2002 18:33 To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Serializi

Re: [DOTNET] Serializing to SQL Table

2002-04-24 Thread Pradeep Tapadiya
I will be travelling between Apr 24 and Apr 28. Will reply after I return. Regards, Pradeep http://www.tapadiya.net/pradeep You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.

Re: [DOTNET] Serializing to SQL Table

2002-04-24 Thread Graeme Foster
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

Re: [DOTNET] Serializing to SQL Table

2002-04-24 Thread Duncan Smart
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", myBy

Re: [DOTNET] Serializing to SQL Table

2002-04-23 Thread Stefan Finch
You can use XSD.exe to generate a XSD schema based on your class. Combine this with the XSD support introduced in SQLServer2000 Web Release 2 (SQLXML2) and you should be on your way HTH S -Original Message- From: Wayne Enis [mailto:[EMAIL PROTECTED]] Sent: 23 April 2002 08:46 To: [EMAI