XML DataSet•Use SQLXML 3.0 Web Services to Return DataSets

Listing A. Users who aren't connected to the database server on a LAN or VPN can download detailed product and customer data over the Internet by consuming a SQLXML 3.0 Web service. This stream contains data for 695 consumer electronics products with fictitious prices. You don't need to change rowset to NewDataSet for read-only operations. Secure data transfer requires Secure Sockets Layer/Transport Layer Security (SSL/TLS) transport or an ASP.NET Web service with message encryption by the Web Services Extensions (WSE) 1.0 or later.

<?xml version="1.0" standalone="yes"?>
<rowset>
   <xs:schema id="rowset" xmlns="" 
         xmlns:xs="http://www.w3.org/2001/XMLSchema" 
         xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
      <xs:element name="rowset" msdata:IsDataSet="true">
         <xs:complexType>
            <xs:choice maxOccurs="unbounded">
               <xs:element name="row">
                  <xs:complexType>
                     <xs:sequence>
                        <xs:element name="sku" type="xs:string" 
                              minOccurs="0" />
                        <xs:element name="catName" type="xs:string" 
                              minOccurs="0" />
                        <xs:element name="brName" type="xs:string" 
                              minOccurs="0" />
                        <xs:element name="model" type="xs:string" 
                              minOccurs="0" />
                        <xs:element name="descr" type="xs:string" 
                              minOccurs="0" />
                        <xs:element name="netPrice" type="xs:decimal" 
                              minOccurs="0" />
                        <xs:element name="shipWt" type="xs:decimal" 
                              minOccurs="0" />
                        <xs:element name="outSrcd" type="xs:boolean" 
                              minOccurs="0" />
                     </xs:sequence>
                  </xs:complexType>
               </xs:element>
            </xs:choice>
         </xs:complexType>
      </xs:element>
   </xs:schema>
   <row>
      <sku>AMPL0693</sku>
      <catName>Amplifiers</catName>
      <brName>Onkyo</brName>
      <model>M-282</model>
      <descr>100-Watt Stereo Amplifier</descr>
      <netPrice>299.95</netPrice>
      <shipWt>11.3</shipWt>
      <outSrcd>false</outSrcd>
   </row>
   <!-- 693 items omitted for brevity -->
   <row>
      <sku>TVRC0633</sku>
      <catName>TV Sets</catName>
      <brName>Sony</brName>
      <model>SAT-HD100</model>
      <descr>HDTV/DTV/DIRECTV/NTSC Digital Receiver</descr>
      <netPrice>799.95</netPrice>
      <shipWt>30.0</shipWt>
      <outSrcd>true</outSrcd>
   </row>
</rowset>