Click here to Skip to main content
15,895,799 members
Articles / Programming Languages / XML

NoteBook using XML and ADO.NET

Rate me:
Please Sign up or sign in to vote.
3.67/5 (15 votes)
22 Dec 20024 min read 102.5K   2K   45  
An article on using XML and ADO.NET to create an appointment/address book.
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="AllTables" targetNamespace="http://tempuri.org/AllTables.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/AllTables.xsd" xmlns:mstns="http://tempuri.org/AllTables.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
	<xs:element name="NoteBook">
		<xs:complexType>
			<xs:sequence>
				<xs:element name="AddressBook">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="address_ID" type="xs:int" msdata:AutoIncrement="true" />
							<xs:element name="fullName" type="xs:string" nillable="false" />
							<xs:element name="organization" type="xs:string" minOccurs="0" nillable="true" />
							<xs:element name="mobile" type="xs:string" maxOccurs="unbounded" minOccurs="0" nillable="true" />
							<xs:element name="homePhone" type="xs:string" maxOccurs="unbounded" minOccurs="0" nillable="true" />
							<xs:element name="workPhone" type="xs:string" maxOccurs="unbounded" minOccurs="0" nillable="true" />
							<xs:element name="email" type="xs:string" maxOccurs="unbounded" minOccurs="0" nillable="true" />
							<xs:element name="mailAddress" type="xs:string" minOccurs="0" nillable="true" />
							<xs:element name="note" type="xs:string" minOccurs="0" nillable="true" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:sequence>
		</xs:complexType>
		<xs:key name="NoteBookKey1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:AddressBook" />
			<xs:field xpath="mstns:address_ID" />
		</xs:key>
	</xs:element>
</xs:schema>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.


Written By
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions