How to convert DataTable to Base64?

[Rodusa]

I am looking for an example of how to save a DataTable into Base64 and
vice-versa. I tried using Convert.ToBase64String(), but it says that it
cannot convert DataTable to byte[]. Any help or pointing would be
appreciated.

Thanks

Rod

 

[Nicholas Paldino [.NET/C# MVP]]

Rodusa,

The easiest way to do this would be to get the contents of the DataTable
in XML, then convert that to a byte array, then convert that to the base 64
string. To get the XML, use the WriteXml method on the DataTable (this
might be new for 2.0, I can't remember, if so, then use the WriteXml method
on the DataSet that the DataTable is in). Once you have the XML, you can
convert to a byte array using one of the Encoding classes (use
UnicodeEncoding if you don't know the encodings of the XML, or another more
appropriate one if you know the encoding will always be the same). Once you
have the bytes from the encoding, getting the base 64 string is easy.

Hope this helps.

 

[Rodusa]

Nicholas,

Thank you. I will try that.

Rod

 

[James Curran]

Note that once it's in XML format, it's probably already in a form
sufficent for what you were planning to use the Base64 for (most of the
troublsome codes would have been converted to characters < 0x80)

--
--
Truth,
James Curran
[erstwhile VC++ MVP]

Home: www.noveltheory.com Work: www.njtheater.com
Blog: www.honestillusion.com Day Job: www.partsearch.com