Hi all,

I've generated a DataSet from a schema. One of the elements is defined as hexBinary type. In the DataSet it becomes a property (column) of a row in a table with the type byte[]. The name of the hexBinary element is PayLoad and it has an equivalent property name PayLoad of a row in a table named Assignment. Here is the portion of the code that loads the XML into the DataSet and writes to a file:

myDataSet.ReadXML(sXMLFile);
StreamWriter sw = StreamWriter("c:\temp2\payload.zip");
SoapHexBinary hb = new SoapHexBinary(myDataSet.Assignment[0].PayLoad);
sw.Write(hb.ToString());
sw.Close();

The problem is that the content saved in the file is quite different from what was transmitted in the PayLoad element. Therefore the saved zip file cannot be opened.

But if I write the XML to a file from the DataSet as follows:

myDataSet.WriteXML("c:\temp2\newxmlfile.xml");

The content in the PayLoad element is correct.


I'd be grateful for any help or suggestion.