dataset2.xsd

人事管理系统（VB.NET2005+SQL Server2005）

              <Mapping SourceColumn="birthday" DataSetColumn="birthday" />
              <Mapping SourceColumn="marry" DataSetColumn="marry" />
              <Mapping SourceColumn="mobile" DataSetColumn="mobile" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="hire_date" DataSetColumn="hire_date" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="work_age" DataSetColumn="work_age" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet2" msprop:Generator_DataSetName="DataSet2">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="employee" msprop:Generator_UserTableName="employee" msprop:Generator_RowDeletedName="employeeRowDeleted" msprop:Generator_TableClassName="employeeDataTable" msprop:Generator_RowChangedName="employeeRowChanged" msprop:Generator_RowClassName="employeeRow" msprop:Generator_RowChangingName="employeeRowChanging" msprop:Generator_RowEvArgName="employeeRowChangeEvent" msprop:Generator_RowEvHandlerName="employeeRowChangeEventHandler" msprop:Generator_TablePropName="employee" msprop:Generator_TableVarName="tableemployee" msprop:Generator_RowDeletingName="employeeRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sex" msprop:Generator_UserColumnName="sex" msprop:Generator_ColumnPropNameInRow="sex" msprop:Generator_ColumnVarNameInTable="columnsex" msprop:Generator_ColumnPropNameInTable="sexColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="birthday" msprop:Generator_UserColumnName="birthday" msprop:Generator_ColumnPropNameInRow="birthday" msprop:Generator_ColumnVarNameInTable="columnbirthday" msprop:Generator_ColumnPropNameInTable="birthdayColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="marry" msprop:Generator_UserColumnName="marry" msprop:Generator_ColumnPropNameInRow="marry" msprop:Generator_ColumnVarNameInTable="columnmarry" msprop:Generator_ColumnPropNameInTable="marryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mobile" msprop:Generator_UserColumnName="mobile" msprop:Generator_ColumnPropNameInRow="mobile" msprop:Generator_ColumnVarNameInTable="columnmobile" msprop:Generator_ColumnPropNameInTable="mobileColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="address" msprop:Generator_UserColumnName="address" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInTable="addressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hire_date" msprop:Generator_UserColumnName="hire_date" msprop:Generator_ColumnPropNameInRow="hire_date" msprop:Generator_ColumnVarNameInTable="columnhire_date" msprop:Generator_ColumnPropNameInTable="hire_dateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="work_age" msprop:Generator_UserColumnName="work_age" msprop:Generator_ColumnPropNameInRow="work_age" msprop:Generator_ColumnVarNameInTable="columnwork_age" msprop:Generator_ColumnPropNameInTable="work_ageColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>