Converting a Temp-Table (buffer handle) to .NET DataTable

Posted by Kim Ward on 21-Jul-2017 01:46

Morning. 

I'm currently writing a class to handle writing data to an Excel Spreadsheets using the Aspose Cells API. Writing the data out from a .NET DataTable seems to be the quickest method of doing this that I've found. To achieve this I am the tables XML to a longchar and reading it into a Syetem.Data.DataSet then extracting the table from there. This seemed to work however I have just noticed that fields with extents are ignoring when they are being read into the DataSet / DataTable.

Has anyone else had any issues with this or potentially knows a better method of doing it?

Thanks,

Kim

DEFINE VARIABLE oDataSet   AS DataSet   NO-UNDO.
DEFINE VARIABLE oDataTable AS DataTable NO-UNDO.

hTable:WRITE-XML("longchar", lcData, false, ?, ?, TRUE).               
                
ASSIGN oDataset   = NEW DataSet()
      oDataTable = NEW DataTable().
        
oDataSet:ReadXml(NEW System.IO.StringReader(lcData), XmlReadMode:InferTypedSchema).
oDataTable = oDataSet:Tables[0].

All Replies

This thread is closed