The following two functions are exchanged between XML and datatable:
Private StringConvertdatatabletoxml (datatable xmlds)
{
Memorystream stream =Null;
Xmltextwriter writer =Null;
Try
{
Stream =NewMemorystream ();
Writer =NewXmltextwriter (stream, encoding. Default );
Xmlds. writexml (writer );
IntCount = (Int) Stream. length;
Byte[] Arr =New Byte[Count];
Stream. Seek (0, seekorigin. Begin );
Stream. Read (ARR, 0, count );
Utf8encoding UTF =NewUtf8encoding ();
ReturnUTF. getstring (ARR). Trim ();
}
Catch
{
ReturnString. empty;
}
Finally
{
If(Writer! =Null) Writer. Close ();
}
}
PrivateDataset convertxmltodataset (StringXmldata)
{
Stringreader stream =Null;
Xmltextreader reader =Null;
Try
{
Dataset xmlds =NewDataset ();
Stream =NewStringreader (xmldata );
Reader =NewXmltextreader (Stream );
Xmlds. readxml (Reader );
ReturnXmlds;
}
Catch(Exception ex)
{
StringStrtest = ex. message;
Return Null;
}
Finally
{
If(Reader! =Null)
Reader. Close ();
}
}