EDN Admin
Well-known member
<p style="margin-bottom:0pt; line-height:normal <span style="font-family:Arial,sans-serif I am using Visual Studio 2008 Pro and programming in Visual Basic and having some issues with Xml schemas.
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="font-family:Arial,sans-serif I’ve created an Xml schema file that I hope to use to validate an Xml data file. I want to be able to control whether and how the datafile is read when it contains
an error. My goal is to validate and import the data (from the Xml file) to a dataSet and then process it. It looks like I am having problems with the the Xml shema. When I try to read the data I get errors for each element and line of data in the
Xml table. The errors look like this:
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="font-size:8pt; font-family:Courier New Validation Error: Could not find schema information for the element TFRTable.
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal
<div style="border-right:medium none; padding-right:0cm
<p style="border-right:medium none; padding-right:0cm; padding-bottom:0cm <span style="font-family:Arial,sans-serif I have included my code, Xml schema and a piece of the Xml data file below. Any plain language help would be much appreciated.
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif
<pre class="prettyprint lang-vb Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ds As New DataSet, rdr As XmlReader
Dim myXmlFile As String = "C:someFile.xml", schemaFile As String = " C:someFile.xsd"
rdr = readXmlWithXmlReader(schemaFile, myXmlFile)
ds.ReadXml(rdr, XmlReadMode.IgnoreSchema)
DataGridView1.DataSource = ds
DataGridView1.DataMember = ds.Tables(0).TableName
End Sub
Function readAndValidate(ByVal schemaFileStr As String, ByVal xmlFileStr As String) As XmlReader
Dim xsc As XmlSchemaSet = New XmlSchemaSet()
xsc.Add(Nothing, schemaFileStr)
Dim settings As New XmlReaderSettings()
settings.ConformanceLevel = ConformanceLevel.Document
settings.IgnoreWhitespace = True
settings.IgnoreComments = True
settings.ValidationType = ValidationType.Schema
settings.Schemas = xsc
settings.ValidationFlags = XmlSchemaValidationFlags.ReportValidationWarnings
AddHandler settings.ValidationEventHandler, AddressOf validator
Dim reader As XmlReader = XmlReader.Create(xmlFileStr, settings)
While reader.Read()
End While
Return reader
End Function
Sub validator(ByVal sender As Object, ByVal e As ValidationEventArgs)
Console.WriteLine("Validation Error: {0}", e.Message)
End Sub[/code]
<p style="margin-bottom:0pt; line-height:normal <span style="font-size:12pt; font-family:Arial,sans-serif XML Schema:
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <?<span style="color:#a31515; font-family:Arial,sans-serif xml<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif version<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1.0"<span style="color:blue
<span style="color:red encoding<span style="color:blue ="<span style="color:blue utf-8"<span style="color:blue ?>
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <<span style="color:#a31515; font-family:Arial,sans-serif xs:schema<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif id<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue FertSchema"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif targetNamespace<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue http://tempuri.org/FertSchema.xsd"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif elementFormDefault<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue qualified"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif xmlns<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue http://tempuri.org/FertSchema.xsd"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif xmlns:mstns<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue http://tempuri.org/FertSchema.xsd"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif xmlns:xs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue http://www.w3.org/2001/XMLSchema"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue yearType"<span style="color:blue
>
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif base<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue xs:unsignedShort"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:minInclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1971"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:maxInclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 2101"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue tfrType"<span style="color:blue
>
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif base<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue xs:decimal"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:minInclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 0"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:maxExclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue frType"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif base<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue xs:decimal"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:minInclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 0"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:maxExclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 10"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span> <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue TFRTable"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:complexType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:sequence<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif maxOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue unbounded"<span style="color:blue
<span style="color:red minOccurs<span style="color:blue ="<span style="color:blue 1"<span style="color:blue
<span style="color:red name<span style="color:blue ="<span style="color:blue TFRRow"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:complexType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:sequence<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue Year"<span style="color:blue
<span style="color:red minOccurs<span style="color:blue ="<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red type<span style="color:blue ="<span style="color:blue yearType"<span style="color:blue <span>
/>
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue tfr"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue tfrType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr1519"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr2024"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr2529"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr3034"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr3539"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr4044"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr4549"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue
<span style="color:red name<span style="color:blue ="<span style="color:blue mbr"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:sequence<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:complexType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:sequence<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:complexType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:schema<span style="color:blue; font-family:Arial,sans-serif >
<span style="font-family:Arial,sans-serif Extract from XML table file:
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <?
<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif xml<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif
<span style="font-size:11pt; color:red; font-family:Arial,sans-serif version<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif =<span style="font-size:11pt; font-family:Arial,sans-serif "<span style="color:blue 1.0"<span style="color:blue
<span style="color:red encoding<span style="color:blue ="<span style="color:blue UTF-8"<span style="color:blue
<span style="color:red standalone<span style="color:blue ="<span style="color:blue yes"<span style="color:blue ?>
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif TFRTable<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif
<span style="font-size:11pt; color:red; font-family:Arial,sans-serif xmlns:xsi<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif =<span style="font-size:11pt; font-family:Arial,sans-serif "<span style="color:blue http://www.w3.org/2001/XMLSchema-instance"<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif TFRRow<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif Year<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 1971<span style="color:blue </<span style="color:#a31515 Year<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif tfr<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 2.1271<span style="color:blue </<span style="color:#a31515 tfr<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr1519<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.03988
<span style="color:blue </<span style="color:#a31515 fr1519<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr2024<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.1293<span style="color:blue </<span style="color:#a31515 fr2024<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr2529<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.13774<span style="color:blue </<span style="color:#a31515 fr2529<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr3034<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.07526<span style="color:blue </<span style="color:#a31515 fr3034<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr3539<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.03334<span style="color:blue </<span style="color:#a31515 fr3539<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr4044<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.0093<span style="color:blue </<span style="color:#a31515 fr4044<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr4549<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.0006<span style="color:blue </<span style="color:#a31515 fr4549<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif mbr<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.51314<span style="color:blue </<span style="color:#a31515 mbr<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif </<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif TFRRow<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif .
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif .
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif </<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif TFRTable<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif >
View the full article
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="font-family:Arial,sans-serif I’ve created an Xml schema file that I hope to use to validate an Xml data file. I want to be able to control whether and how the datafile is read when it contains
an error. My goal is to validate and import the data (from the Xml file) to a dataSet and then process it. It looks like I am having problems with the the Xml shema. When I try to read the data I get errors for each element and line of data in the
Xml table. The errors look like this:
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="font-size:8pt; font-family:Courier New Validation Error: Could not find schema information for the element TFRTable.
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal
<div style="border-right:medium none; padding-right:0cm
<p style="border-right:medium none; padding-right:0cm; padding-bottom:0cm <span style="font-family:Arial,sans-serif I have included my code, Xml schema and a piece of the Xml data file below. Any plain language help would be much appreciated.
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif
<pre class="prettyprint lang-vb Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ds As New DataSet, rdr As XmlReader
Dim myXmlFile As String = "C:someFile.xml", schemaFile As String = " C:someFile.xsd"
rdr = readXmlWithXmlReader(schemaFile, myXmlFile)
ds.ReadXml(rdr, XmlReadMode.IgnoreSchema)
DataGridView1.DataSource = ds
DataGridView1.DataMember = ds.Tables(0).TableName
End Sub
Function readAndValidate(ByVal schemaFileStr As String, ByVal xmlFileStr As String) As XmlReader
Dim xsc As XmlSchemaSet = New XmlSchemaSet()
xsc.Add(Nothing, schemaFileStr)
Dim settings As New XmlReaderSettings()
settings.ConformanceLevel = ConformanceLevel.Document
settings.IgnoreWhitespace = True
settings.IgnoreComments = True
settings.ValidationType = ValidationType.Schema
settings.Schemas = xsc
settings.ValidationFlags = XmlSchemaValidationFlags.ReportValidationWarnings
AddHandler settings.ValidationEventHandler, AddressOf validator
Dim reader As XmlReader = XmlReader.Create(xmlFileStr, settings)
While reader.Read()
End While
Return reader
End Function
Sub validator(ByVal sender As Object, ByVal e As ValidationEventArgs)
Console.WriteLine("Validation Error: {0}", e.Message)
End Sub[/code]
<p style="margin-bottom:0pt; line-height:normal <span style="font-size:12pt; font-family:Arial,sans-serif XML Schema:
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <?<span style="color:#a31515; font-family:Arial,sans-serif xml<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif version<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1.0"<span style="color:blue
<span style="color:red encoding<span style="color:blue ="<span style="color:blue utf-8"<span style="color:blue ?>
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <<span style="color:#a31515; font-family:Arial,sans-serif xs:schema<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif id<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue FertSchema"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif targetNamespace<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue http://tempuri.org/FertSchema.xsd"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif elementFormDefault<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue qualified"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif xmlns<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue http://tempuri.org/FertSchema.xsd"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif xmlns:mstns<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue http://tempuri.org/FertSchema.xsd"
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif xmlns:xs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue http://www.w3.org/2001/XMLSchema"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue yearType"<span style="color:blue
>
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif base<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue xs:unsignedShort"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:minInclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1971"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:maxInclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 2101"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue tfrType"<span style="color:blue
>
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif base<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue xs:decimal"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:minInclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 0"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:maxExclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue frType"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif base<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue xs:decimal"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:minInclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 0"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:maxExclusive<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif value<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 10"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:restriction<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:simpleType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span> <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue TFRTable"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:complexType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:sequence<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif maxOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue unbounded"<span style="color:blue
<span style="color:red minOccurs<span style="color:blue ="<span style="color:blue 1"<span style="color:blue
<span style="color:red name<span style="color:blue ="<span style="color:blue TFRRow"<span style="color:blue >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:complexType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:sequence<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif name<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue Year"<span style="color:blue
<span style="color:red minOccurs<span style="color:blue ="<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red type<span style="color:blue ="<span style="color:blue yearType"<span style="color:blue <span>
/>
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue tfr"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue tfrType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr1519"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr2024"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr2529"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr3034"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr3539"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr4044"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue <span>
<span style="color:red name<span style="color:blue ="<span style="color:blue fr4549"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
<<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif <span>
<span style="color:red; font-family:Arial,sans-serif minOccurs<span style="color:blue; font-family:Arial,sans-serif =<span style="font-family:Arial,sans-serif "<span style="color:blue 1"<span style="color:blue
<span style="color:red name<span style="color:blue ="<span style="color:blue mbr"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue frType"<span style="color:blue />
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:sequence<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:complexType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:sequence<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:complexType<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:element<span style="color:blue; font-family:Arial,sans-serif >
<p style="margin-bottom:0pt; line-height:normal <span style="color:blue; font-family:Arial,sans-serif <span>
</<span style="color:#a31515; font-family:Arial,sans-serif xs:schema<span style="color:blue; font-family:Arial,sans-serif >
<span style="font-family:Arial,sans-serif Extract from XML table file:
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <?
<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif xml<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif
<span style="font-size:11pt; color:red; font-family:Arial,sans-serif version<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif =<span style="font-size:11pt; font-family:Arial,sans-serif "<span style="color:blue 1.0"<span style="color:blue
<span style="color:red encoding<span style="color:blue ="<span style="color:blue UTF-8"<span style="color:blue
<span style="color:red standalone<span style="color:blue ="<span style="color:blue yes"<span style="color:blue ?>
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif TFRTable<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif
<span style="font-size:11pt; color:red; font-family:Arial,sans-serif xmlns:xsi<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif =<span style="font-size:11pt; font-family:Arial,sans-serif "<span style="color:blue http://www.w3.org/2001/XMLSchema-instance"<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif TFRRow<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif Year<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 1971<span style="color:blue </<span style="color:#a31515 Year<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif tfr<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 2.1271<span style="color:blue </<span style="color:#a31515 tfr<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr1519<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.03988
<span style="color:blue </<span style="color:#a31515 fr1519<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr2024<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.1293<span style="color:blue </<span style="color:#a31515 fr2024<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr2529<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.13774<span style="color:blue </<span style="color:#a31515 fr2529<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr3034<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.07526<span style="color:blue </<span style="color:#a31515 fr3034<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr3539<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.03334<span style="color:blue </<span style="color:#a31515 fr3539<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr4044<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.0093<span style="color:blue </<span style="color:#a31515 fr4044<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif fr4549<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.0006<span style="color:blue </<span style="color:#a31515 fr4549<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif <<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif mbr<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif ><span style="font-size:11pt; font-family:Arial,sans-serif 0.51314<span style="color:blue </<span style="color:#a31515 mbr<span style="color:blue >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif </<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif TFRRow<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif >
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif .
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif .
<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif </<span style="font-size:11pt; color:#a31515; font-family:Arial,sans-serif TFRTable<span style="font-size:11pt; color:blue; font-family:Arial,sans-serif >
View the full article