Lets assume we have a database query and we want to format it in XML as a table. That would be something like this:
QXmlStreamWriter writer( &xmlText );
writer.writeStartDocument( "1.0" );
writer.writeStartElement( "table" );
while ( query.next() ) {
writer.writeStartElement( "row" );
for ( int col = 0; col < row.count(); ++col ) {
writer.writeStartElement( "column" );
writer.writeAttribute( "name", field.name() );
writer.writeCharacters( field.value().toString() );
writer.writeEndElement(); // column
}
writer.writeEndElement(); // row
}
writer.writeEndElement(); // table
writer.writeEndDocument();
QString xmlText;
QXmlStreamWriter writer( &xmlText );
writer.writeStartDocument( "1.0" );
writer.writeStartElement( "table" );
while ( query.next() ) {
QSqlRecord row = query.record();
writer.writeStartElement( "row" );
for ( int col = 0; col < row.count(); ++col ) {
QSqlField column = row.field( col );
writer.writeStartElement( "column" );
writer.writeAttribute( "name", field.name() );
writer.writeCharacters( field.value().toString() );
writer.writeEndElement(); // column
}
writer.writeEndElement(); // row
}
writer.writeEndElement(); // table
writer.writeEndDocument();
To copy to clipboard, switch view to plain text mode
Cheers,
_
Bookmarks