DataSet to XMl and XML to Dataset

Question

From database a table contains a column of image datatype .I bind that table with the dataset the dataset fills.

After the dataset fills it contains many of other datatype but in image datatype it conatins System.Byte[] Data.

so from the above.

Suppose a dataset column contains system.Byte[] datas how to write it in XML file.

And how to fetch the data from that same XML file to dataset so that the dataset

should conatin the same system.Byte[] datas

Vulpes · Answer

You could convert the byte array (ba say) to a hex string and then save that in the XML file. The code to do that and recover it again afterwards would be on these lines: var sb = new System.Text.StringBuilder(); foreach(byte b in ba) sb.Append(b.ToString(x2)); string s = sb.ToString(); // s can now be stored in an XML file // to recover the byte array from a string s retrieved from the XML file byte[] ba2 = new byte[s.Length/2]; for(int i = 0; i { ba2[i/2] = Convert.ToByte(s.Substring(i 2) 16); }