serialize to SQL Server Blob instead of XML serialize

[Gordz]

I've been experiencing problems on some computers with XML Serialization. On
some computers the files do not get created on the web server's hard drive
and it's been driving me nuts trying to figure it out.

I store navigation history and application state in object collections and
save this upon application exit by doing an XML.Serialize.

I'd like to serialize directly to SQL Server instead. Can I create a stream
object to be used by SQL Server with serialization?

Thanks

[John Oakes]

Yeah, this is the basics (DT is just an object I'm taking from session and
serializing):

Dim ms As New MemoryStream
ms = SerializeDT(CTy pe(Session("DT" ), DTProcess))
Dim da() As Byte
da = ms.ToArray
cmd.Parameters( "@DesktopData") .Value = da
SqlConnection1. Open()
cmd.ExecuteNonQ uery()
SqlConnection1. Close()

Public Shared Function SerializeDT(ByV al DTSource As DTProcess) As
MemoryStream
Dim ms As New MemoryStream
Dim formatter As New BinaryFormatter
formatter.Seria lize(ms, DTSource)
ms.Position = 0
Return ms
End Function

-John Oakes
"Gordz" <jo*****@aol.co m> wrote in message
news:10******** ****@corp.super news.com...

I've been experiencing problems on some computers with XML Serialization. On some computers the files do not get created on the web server's hard drive
and it's been driving me nuts trying to figure it out.

I store navigation history and application state in object collections and
save this upon application exit by doing an XML.Serialize.

I'd like to serialize directly to SQL Server instead. Can I create a stream object to be used by SQL Server with serialization?

Thanks

[Gordz]

thanks John.

I've never used binary objects in SQL before.

Where exactly is your data "@DesktopDa ta" stored in the database? Do you
have a field already defined?

Cheers,

Gord

"John Oakes" <jo**@nospam.ne tworkproduction s.net> wrote in message
news:Ow******** ********@TK2MSF TNGP12.phx.gbl. ..
Yeah, this is the basics (DT is just an object I'm taking from session and
serializing):

Dim ms As New MemoryStream
ms = SerializeDT(CTy pe(Session("DT" ), DTProcess))
Dim da() As Byte
da = ms.ToArray
cmd.Parameters( "@DesktopData") .Value = da
SqlConnection1. Open()
cmd.ExecuteNonQ uery()
SqlConnection1. Close()

Public Shared Function SerializeDT(ByV al DTSource As DTProcess) As
MemoryStream
Dim ms As New MemoryStream
Dim formatter As New BinaryFormatter
formatter.Seria lize(ms, DTSource)
ms.Position = 0
Return ms
End Function

-John Oakes
"Gordz" <jo*****@aol.co m> wrote in message
news:10******** ****@corp.super news.com...

I've been experiencing problems on some computers with XML Serialization. On some computers the files do not get created on the web server's hard drive
and it's been driving me nuts trying to figure it out.

I store navigation history and application state in object collections and
save this upon application exit by doing an XML.Serialize.

I'd like to serialize directly to SQL Server instead. Can I create a stream object to be used by SQL Server with serialization?

Thanks

[John Oakes]

Yes, I have a field defined. The datatype is image, which is
variable-length binary data from 0 through 231-1 (2,147,483,647) bytes.

-John Oakes
"Gordz" <jo*****@aol.co m> wrote in message
news:10******** *****@corp.supe rnews.com...

thanks John.

I've never used binary objects in SQL before.

Where exactly is your data "@DesktopDa ta" stored in the database? Do you
have a field already defined?

Cheers,

Gord

"John Oakes" <jo**@nospam.ne tworkproduction s.net> wrote in message
news:Ow******** ********@TK2MSF TNGP12.phx.gbl. ..
Yeah, this is the basics (DT is just an object I'm taking from session and
serializing):

Dim ms As New MemoryStream
ms = SerializeDT(CTy pe(Session("DT" ), DTProcess))
Dim da() As Byte
da = ms.ToArray
cmd.Parameters( "@DesktopData") .Value = da
SqlConnection1. Open()
cmd.ExecuteNonQ uery()
SqlConnection1. Close()

Public Shared Function SerializeDT(ByV al DTSource As DTProcess) As
MemoryStream
Dim ms As New MemoryStream
Dim formatter As New BinaryFormatter
formatter.Seria lize(ms, DTSource)
ms.Position = 0
Return ms
End Function

-John Oakes
"Gordz" <jo*****@aol.co m> wrote in message
news:10******** ****@corp.super news.com...

I've been experiencing problems on some computers with XML Serialization.

On

some computers the files do not get created on the web server's hard

drive and it's been driving me nuts trying to figure it out.

I store navigation history and application state in object collections and save this upon application exit by doing an XML.Serialize.

I'd like to serialize directly to SQL Server instead. Can I create a

stream

object to be used by SQL Server with serialization?

Thanks