Displaying ADO Retrieved Data with XML Islands - The Saved XML file

(Page 3 of 7 )

If you open the file C:NwindEmployees.xml in a text editor you can see the full details.

<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:updatable='true'>

               <s:AttributeType name='Address' rs:number='8' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='Address'>

                       <s:datatype dt:type='string' dt:maxLength='60'/>

               </s:AttributeType>

               <s:AttributeType name='BirthDate' rs:number='6' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='BirthDate'>

                       <s:datatype dt:type='DateTime' 

rs:dbtype='variantdate' dt:maxLength='16' rs:fixedlength='true'/>

               </s:AttributeType>

               <s:AttributeType name='City' rs:number='9' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='City'>

                       <s:datatype dt:type='string' dt:maxLength='15'/>

               </s:AttributeType>

               <s:AttributeType name='Country' rs:number='12' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='Country'>

                       <s:datatype dt:type='string' dt:maxLength='15'/>

               </s:AttributeType>

               <s:AttributeType name='EmployeeID' rs:number='1' 

rs:maydefer='true' rs:writeunknown='true' rs:basetable='Employees'

                        rs:basecolumn='EmployeeID' 

rs:autoincrement='true'>

                       <s:datatype dt:type='int' dt:maxLength='4' 

rs:precision='10' rs:fixedlength='true'/>

               </s:AttributeType>

               <s:AttributeType name='Extension' rs:number='14' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='Extension'>

                       <s:datatype dt:type='string' dt:maxLength='4'/>

               </s:AttributeType>

               <s:AttributeType name='FirstName' rs:number='3' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='FirstName'>

                       <s:datatype dt:type='string' dt:maxLength='10'/>

               </s:AttributeType>

               <s:AttributeType name='HireDate' rs:number='7' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='HireDate'>

                       <s:datatype dt:type='dateTime' 

rs:dbtype='variantdate' dt:maxLength='16' rs:fixedlength='true'/>

               </s:AttributeType>

               <s:AttributeType name='HomePhone' rs:number='13' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='HomePhone'>

                       <s:datatype dt:type='string' dt:maxLength='24'/>

               </s:AttributeType>

               <s:AttributeType name='LastName' rs:number='2' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='LastName'>

                       <s:datatype dt:type='string' dt:maxLength='20'/>

               </s:AttributeType>

               <s:AttributeType name='Notes' rs:number='16' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='Notes'>

                       <s:datatype dt:type='string' 

dt:maxLength='536870910' rs:long='true'/>

               </s:AttributeType>

               <s:AttributeType name='Photo' rs:number='15' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='Photo'>

                       <s:datatype dt:type='string' dt:maxLength='255'/>

               </s:AttributeType>

               <s:AttributeType name='PostalCode' rs:number='11' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='PostalCode'>

                       <s:datatype dt:type='string' dt:maxLength='10'/>

               </s:AttributeType>

               <s:AttributeType name='Region' rs:number='10' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='Region'>

                       <s:datatype dt:type='string' dt:maxLength='15'/>

               </s:AttributeType>

               <s:AttributeType name='ReportsTo' rs:number='17' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='ReportsTo'>

                       <s:datatype dt:type='int' dt:maxLength='4' 

rs:precision='10' rs:fixedlength='true'/>

               </s:AttributeType>

               <s:AttributeType name='Title' rs:number='4' 

rs:nullable='true' rs:maydefer='true' rs:write='true' 

rs:basetable='Employees'

                        rs:basecolumn='Title'>

                       <s:datatype dt:type='string' dt:maxLength='30'/>

               </s:AttributeType>

               <s:AttributeType name='TitleOfCourtesy' 

rs:number='5' rs:nullable='true' rs:maydefer='true' rs:write='true'

                        rs:basetable='Employees' 

rs:basecolumn='TitleOfCourtesy'>

                       <s:datatype dt:type='string' dt:maxLength='25'/>

               </s:AttributeType>

               <s:extends type='rs:rowbase'/>

        </s:ElementType>

</s:Schema>

<rs:data>

        <z:row Address='4110 Old Redmond Rd.' 

BirthDate='1958-09-19T00:00:00' City='Redmond' Country='USA' 

EmployeeID='4'

                Extension='5176' FirstName='Margaret' 

HireDate='1993-05-03T00:00:00' HomePhone='(206) 555-8122' 

LastName='Peacock'

                Notes='Margaret holds a BA in English literature from 

Concordia College and an MA from the American Institute of Culinary Arts. 

She was temporarily assigned to the London office before returning to her 

permanent post in Seattle.'

                Photo='EmpID4.bmp' PostalCode='98052' Region='WA' 

ReportsTo='2' Title='Sales Representative' TitleOfCourtesy='Mrs.'/>

</rs:data>

</xml>

Next: Reviewing the saved file >>
 

More XML Articles
More By Jayaram Krishnaswamy

Comments On: Displaying ADO Retrieved Data with XML Islands

· ADO was indeed a milestone in Microsoft's data access technology. It replaced the...   >>> Post your comment now!