XML / XSL

<PhysicalAddr><br />
		<Line>Physical line 1</Line><br />
		<Line>Physical line 2</Line><br />
		<Line>Physical line 3</Line><br />
	</PhysicalAddr>

<xsd:simpleType name="registration">
- <xsd:restriction base="xsd:string">
  <xsd:pattern value="[0-9]{1,8}[A-Wa-w][TWXtwx ]?" />
  <xsd:pattern value="[7-9][A-Wa-w][0-9]{5}[A-Za-z]" />

Dim XDoc as XPathDocument
Dim xmlNav as XPathNavigator
Dim xmlNI as XPathNodeIterator

XDoc = new XPathDocument("C:\sop.xml")
xmlNav = XDoc.CreateNavigator
xmlNI = xmlNav.Select("/SOP_FILE/QuestionList/Question")

While xmlNI.MoveNext
    MsgBox(xmlNI.Current.Name & " - " & xmlNI.Current.Value)
End While

<?xml version="1.0" encoding="utf-8"?>
<SOP_FILE xmlns="http://schemas.mycompany.com/SOP" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<QuestionList>
<Question Number="1">
<Text>Has a risk assessment been conducted?</Text><Choice Text="Yes" Index="1" PointsTo="2" />
</Question>
<Question Number="2">
<Text>Has an inspection been conducted?</Text><Choice Text="Yes" Index="1" PointsTo="3" />
<Choice Text="No" Index="2" PointsTo="4" />
</Question>
<Question Number="3">
<Text>Is the property lead-based paint free?</Text>
</Question>
</QuestionList>
</SOP_FILE>

<SOP_FILE>

<SOP_FILE xmlns="http://schemas.mycompany.com/SOP" xmlns:xs="http://www.w3.org/2001/XMLSchema">

---------               -------------              ---------- 
| Users |  1 ----- many | UserGroup | many ----- 1 | Groups |
---------               -------------              ---------- 

// sproc returns a dataset containing three tables
SqlDataAdapter da = new SqlDataAdapter( "sproc", connection );
da.SelectCommand.CommandType = CommandType.StoredProcedure;

DataSet ds = new DataSet();
da.Fill(ds);

ds.Tables[0].TableName = "User";
ds.Tables[1].TableName = "Group";
ds.Tables[2].TableName = "UserGroup";

DataRelation ea1 = ds.Relations.Add(
	ds.Tables["User"].Columns["UserID"],
	ds.Tables["UserGroup"].Columns["UserID"],
	false);

DataRelation ea2 = ds.Relations.Add(
	ds.Tables["Group"].Columns["GroupID"],
	ds.Tables["UserGroup"].Columns["GroupID"],
	false);

ea1.Nested = true;
//ea2.Nested = true; // Do I need this?
					
XmlDataDocument doc = new XmlDataDocument(ds);

<Groups>
  <Group>
    <GroupName>Astronauts</GroupName>
    <Users>
      <Name>Neil Armstrong</Name>
      <Name>Buzz Aldrin</Name>
      <Name>Yuri Gagarin</Name>
    <Users>
  </Group>
  <Group>
    <GroupName>Americans</GroupName>
    <Users>
      <Name>Neil Armstrong</Name>
      <Name>Buzz Aldrin</Name>
    </Users>
  </Group>
</Groups>