Serialize to a database

[Guest]

Hello All,

I want to serialize a hashtable to a database table to persist its values
between postbacks. The client requires that I not use ViewState, hence the
database.

The samples in MSDN show how to serialize a class that implements the
ICollection interface to a file. Does anyone know how to serialize to a
database table and conversely de-serialize from the table?

TIA,

 

[Peter Rilling]

All you have to do is serialize the contents as you normally would, which
would produce a set of bytes. Then encode those bytes into base64. When
save the data to some text field in the database.

Then reverse the process to de-serialize.

 

[Guest]

Thanks Peter.

I am not familiar with the encoding into base64. Do you know of an online
example?

--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation

All you have to do is serialize the contents as you normally would, which
would produce a set of bytes. Then encode those bytes into base64. When
save the data to some text field in the database.

Then reverse the process to de-serialize.

 

[Guest]

Pater,

One more qeustion. Why encode in Base64?

Thanks,
--
Joe

VB.NET/C#/ASP.NET/ASP/VB/C++/Web and DB development/VBA Automation

All you have to do is serialize the contents as you normally would, which
would produce a set of bytes. Then encode those bytes into base64. When
save the data to some text field in the database.

Then reverse the process to de-serialize.

 

[Peter Rilling]

The reason is that when you serialize something, at least in binary format,
there are characters that may not play well with text fields. These are
often the control and extended characters. Base64 simple ensures that all
content can be interpreted as ASCII text. Although this may or may not be
necessary, I usually do this to prevent any subtle bugs when stored or
transmitting the data.

You can use the methods Convert.FromBase64String(...) and
Convert.ToBase64String(...).

Pater,

One more qeustion. Why encode in Base64?

Thanks,

 

[Guest]

Thank you very much. I aprpeciate it.

 

[Bruce Barker]

if you use a binary field you can just store the serialized byte array. if
you serialize to xml, then a text field is fine.

-- bruce (sqlwork.com)

Pater,

One more qeustion. Why encode in Base64?

Thanks,