• 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.