Today I added the new feature in SMExport – to create the xml file from dataset which is compatible with ADO.NET.
Small sample code:
smeXML := TSMExportToXML.Create(nil); try smeXML.DataSet := ClientDataSet; smeXML.ColumnSource := csDataset; smeXML.FileName := ADOXMLFileName; smeXML.AddTitle := True; smeXML.Format := xmlADO; smeXML.XMLTags.RowTag := 'z:row'; smeXML.DataFormats.CustomDateTimeFormat := 'yyyy-mm-ddThh:nn:ss'; smeXML.Execute; finally smeXML.Free; end;