The essential question is whether or not to read this fairly simple data from an XML file or from a database. Prior to implementing a new FAQ system, the data were read from the XML file exactly as Peter suggests:
reader = New XmlTextReader(url)
Dim questionObj As Object = reader.NameTable.Add("Question")
Dim answerObj As Object = reader.NameTable.Add("Content")
Dim summaryObj As Object = reader.NameTable.Add("Summary")
Do While reader.Read()
If reader.NodeType = XmlNodeType.Element Then
If reader.Name.Equals(questionObj) Then
Dim content As String = reader.ReadInnerXml
content = content.Remove(0, 4)
content = content.Remove(content.Length - 4, 4)
Me._title = Me.ParseText(content)
template = template.Replace("$Question$", Me._title)
template = template.Replace("$FileID$", fileID)
End If
Etc, etc, etc....
The business problem that I faced was that a new system stored this same data in a db; So, I have "old" data in XML files and "new" data in a db. Hence, the need to import the XML files into SQL Server.