dsorders.xsd

wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载

              <Mapping SourceColumn="EmployeeID" DataSetColumn="EmployeeID" />
              <Mapping SourceColumn="OrderDate" DataSetColumn="OrderDate" />
              <Mapping SourceColumn="RequiredDate" DataSetColumn="RequiredDate" />
              <Mapping SourceColumn="ShippedDate" DataSetColumn="ShippedDate" />
              <Mapping SourceColumn="ShipVia" DataSetColumn="ShipVia" />
              <Mapping SourceColumn="Freight" DataSetColumn="Freight" />
              <Mapping SourceColumn="ShipName" DataSetColumn="ShipName" />
              <Mapping SourceColumn="ShipAddress" DataSetColumn="ShipAddress" />
              <Mapping SourceColumn="ShipCity" DataSetColumn="ShipCity" />
              <Mapping SourceColumn="ShipRegion" DataSetColumn="ShipRegion" />
              <Mapping SourceColumn="ShipPostalCode" DataSetColumn="ShipPostalCode" />
              <Mapping SourceColumn="ShipCountry" DataSetColumn="ShipCountry" />
            </Mappings>
            <Sources>
            </Sources>
          </DbTable>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsOrders" msdata:IsDataSet="true" msdata:EnforceConstraints="False" msprop:User_DataSetName="dsOrders" msprop:DSGenerator_DataSetName="dsOrders">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Orders" msdata:Locale="en-US" msprop:Generator_SuspendValidationVarName="m_suspendValidation" msprop:Generator_SuspendValidationPropName="SuspendValidation" msprop:Generator_TableClassName="OrdersDataTable" msprop:User_TableName="Orders" msprop:Generator_RowClassName="OrdersRow" msprop:Generator_RowEvArgName="OrdersRowChangeEvent" msprop:Generator_RowEvHandlerName="OrdersRowChangeEventHandler" msprop:Generator_TablePropName="Orders" msprop:Generator_TableVarName="tableOrders">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_DelegateName="OrderIDChangeEventHandler" msprop:Generator_ChangingEventName="OrderIDChanging" msprop:Generator_ColumnVarNameInTable="columnOrderID" msprop:Generator_EventArgName="OrderIDChangeEventArg" msprop:User_ColumnName="OrderID" msprop:Generator_ColumnPropNameInRow="OrderID" msprop:Generator_ChangedEventName="OrderIDChanged" msprop:Generator_ColumnPropNameInTable="OrderIDColumn" type="xs:int" />
              <xs:element name="CustomerID" msprop:Generator_DelegateName="CustomerIDChangeEventHandler" msprop:Generator_ChangingEventName="CustomerIDChanging" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_EventArgName="CustomerIDChangeEventArg" msprop:User_ColumnName="CustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ChangedEventName="CustomerIDChanged" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeID" msprop:Generator_DelegateName="EmployeeIDChangeEventHandler" msprop:Generator_ChangingEventName="EmployeeIDChanging" msprop:Generator_ColumnVarNameInTable="columnEmployeeID" msprop:Generator_EventArgName="EmployeeIDChangeEventArg" msprop:User_ColumnName="EmployeeID" msprop:Generator_ColumnPropNameInRow="EmployeeID" msprop:Generator_ChangedEventName="EmployeeIDChanged" msprop:Generator_ColumnPropNameInTable="EmployeeIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="OrderDate" msprop:Generator_DelegateName="OrderDateChangeEventHandler" msprop:Generator_ChangingEventName="OrderDateChanging" msprop:Generator_ColumnVarNameInTable="columnOrderDate" msprop:Generator_EventArgName="OrderDateChangeEventArg" msprop:User_ColumnName="OrderDate" msprop:Generator_ColumnPropNameInRow="OrderDate" msprop:Generator_ChangedEventName="OrderDateChanged" msprop:Generator_ColumnPropNameInTable="OrderDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RequiredDate" msprop:Generator_DelegateName="RequiredDateChangeEventHandler" msprop:Generator_ChangingEventName="RequiredDateChanging" msprop:Generator_ColumnVarNameInTable="columnRequiredDate" msprop:Generator_EventArgName="RequiredDateChangeEventArg" msprop:User_ColumnName="RequiredDate" msprop:Generator_ColumnPropNameInRow="RequiredDate" msprop:Generator_ChangedEventName="RequiredDateChanged" msprop:Generator_ColumnPropNameInTable="RequiredDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ShippedDate" msprop:Generator_DelegateName="ShippedDateChangeEventHandler" msprop:Generator_ChangingEventName="ShippedDateChanging" msprop:Generator_ColumnVarNameInTable="columnShippedDate" msprop:Generator_EventArgName="ShippedDateChangeEventArg" msprop:User_ColumnName="ShippedDate" msprop:Generator_ColumnPropNameInRow="ShippedDate" msprop:Generator_ChangedEventName="ShippedDateChanged" msprop:Generator_ColumnPropNameInTable="ShippedDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ShipVia" msprop:Generator_DelegateName="ShipViaChangeEventHandler" msprop:Generator_ChangingEventName="ShipViaChanging" msprop:Generator_ColumnVarNameInTable="columnShipVia" msprop:Generator_EventArgName="ShipViaChangeEventArg" msprop:User_ColumnName="ShipVia" msprop:Generator_ColumnPropNameInRow="ShipVia" msprop:Generator_ChangedEventName="ShipViaChanged" msprop:Generator_ColumnPropNameInTable="ShipViaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Freight" msprop:Generator_DelegateName="FreightChangeEventHandler" msprop:Generator_ChangingEventName="FreightChanging" msprop:Generator_ColumnVarNameInTable="columnFreight" msprop:Generator_EventArgName="FreightChangeEventArg" msprop:User_ColumnName="Freight" msprop:Generator_ColumnPropNameInRow="Freight" msprop:Generator_ChangedEventName="FreightChanged" msprop:Generator_ColumnPropNameInTable="FreightColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ShipName" msprop:Generator_DelegateName="ShipNameChangeEventHandler" msprop:Generator_ChangingEventName="ShipNameChanging" msprop:Generator_ColumnVarNameInTable="columnShipName" msprop:Generator_EventArgName="ShipNameChangeEventArg" msprop:User_ColumnName="ShipName" msprop:Generator_ColumnPropNameInRow="ShipName" msprop:Generator_ChangedEventName="ShipNameChanged" msprop:Generator_ColumnPropNameInTable="ShipNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipAddress" msprop:Generator_DelegateName="ShipAddressChangeEventHandler" msprop:Generator_ChangingEventName="ShipAddressChanging" msprop:Generator_ColumnVarNameInTable="columnShipAddress" msprop:Generator_EventArgName="ShipAddressChangeEventArg" msprop:User_ColumnName="ShipAddress" msprop:Generator_ColumnPropNameInRow="ShipAddress" msprop:Generator_ChangedEventName="ShipAddressChanged" msprop:Generator_ColumnPropNameInTable="ShipAddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipCity" msprop:Generator_DelegateName="ShipCityChangeEventHandler" msprop:Generator_ChangingEventName="ShipCityChanging" msprop:Generator_ColumnVarNameInTable="columnShipCity" msprop:Generator_EventArgName="ShipCityChangeEventArg" msprop:User_ColumnName="ShipCity" msprop:Generator_ColumnPropNameInRow="ShipCity" msprop:Generator_ChangedEventName="ShipCityChanged" msprop:Generator_ColumnPropNameInTable="ShipCityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipRegion" msprop:Generator_DelegateName="ShipRegionChangeEventHandler" msprop:Generator_ChangingEventName="ShipRegionChanging" msprop:Generator_ColumnVarNameInTable="columnShipRegion" msprop:Generator_EventArgName="ShipRegionChangeEventArg" msprop:User_ColumnName="ShipRegion" msprop:Generator_ColumnPropNameInRow="ShipRegion" msprop:Generator_ChangedEventName="ShipRegionChanged" msprop:Generator_ColumnPropNameInTable="ShipRegionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipPostalCode" msprop:Generator_DelegateName="ShipPostalCodeChangeEventHandler" msprop:Generator_ChangingEventName="ShipPostalCodeChanging" msprop:Generator_ColumnVarNameInTable="columnShipPostalCode" msprop:Generator_EventArgName="ShipPostalCodeChangeEventArg" msprop:User_ColumnName="ShipPostalCode" msprop:Generator_ColumnPropNameInRow="ShipPostalCode" msprop:Generator_ChangedEventName="ShipPostalCodeChanged" msprop:Generator_ColumnPropNameInTable="ShipPostalCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipCountry" msprop:Generator_DelegateName="ShipCountryChangeEventHandler" msprop:Generator_ChangingEventName="ShipCountryChanging" msprop:Generator_ColumnVarNameInTable="columnShipCountry" msprop:Generator_EventArgName="ShipCountryChangeEventArg" msprop:User_ColumnName="ShipCountry" msprop:Generator_ColumnPropNameInRow="ShipCountry" msprop:Generator_ChangedEventName="ShipCountryChanged" msprop:Generator_ColumnPropNameInTable="ShipCountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:OrderID" />
    </xs:unique>
  </xs:element>
</xs:schema>