JOIN DEVPPL

It looks like you are new here. If you want to get involved, click on Join below!



Urgent XML vb6 question


S

keyboard_arrow_up
0
keyboard_arrow_down


First Post Mark as Spam samo
Posts: 1 - Registered: 2004-10-12 02:46:14

i created an xml file from vb6 using adodb save command i.e

recordset.save "C:\xml.xml", adpersistXML

Below is how the xml file looks.

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:CommandTimeout='30' rs:updatable='true'>
<s:AttributeType name='Inspector' rs:number='1' rs:writeunknown='true' rs:basecatalog='DTETRAINER' rs:basetable='tlkpInspector'
rs:basecolumn='Inspector' rs:keycolumn='true'>
<s:datatype dt:type='string' dt:maxLength='50' rs:maybenull='false'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row Inspector='Andrew Webb'/>
<z:row Inspector='Peter Kirk'/>
<z:row Inspector='Alison Unwin'/>
<z:row Inspector='Mark Robertson'/>
<z:row Inspector='A N Other'/>
<z:row Inspector='Philip Jones'/>
</rs:data>
</xml>


right, i use the same method of creating an xml file using visual basic.net except i use a dataset to right the xml file instead of using adodb. i get the following in the xml file.

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<tlkpInspectors>
<Inspector>Andrew Webb</Inspector>
</tlkpInspectors>
<tlkpInspectors>
<Inspector>Peter Kirk</Inspector>
</tlkpInspectors>
<tlkpInspectors>
<Inspector>Alison Unwin</Inspector>
</tlkpInspectors>
<tlkpInspectors>
<Inspector>Mark Robertson</Inspector>
</tlkpInspectors>
<tlkpInspectors>
<Inspector>A N Other</Inspector>
</tlkpInspectors>
<tlkpInspectors>
<Inspector>Philip Jones</Inspector>
</tlkpInspectors>
</NewDataSet>


what i need is for the structure of the xml file created in vb6 to look like the structure of the xml file created in .net. This is because i have an app created for a PDA in .net that uses the xml file to populate an SQLServerCE database. For some reason .net on the PDA does not like the way the xml file created in vb6 is structured and therfor errors out.

Anyway of getting the vb6 xml created file to look like the .net xml created file?

Thanks very much






JOIN DEVPPL

It looks like you are new here. If you want to get involved, click on Join below!




MENU
Advertising