{"id":1364,"date":"2010-10-21T14:16:55","date_gmt":"2010-10-21T12:16:55","guid":{"rendered":"https:\/\/www.peppercrew.nl\/?p=1364"},"modified":"2011-05-19T15:00:10","modified_gmt":"2011-05-19T14:00:10","slug":"true-is-not-true","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/true-is-not-true\/","title":{"rendered":"True is not true (?)"},"content":{"rendered":"
<\/a><\/div>\n
\"The<\/a><\/div>\n
This error is thrown when an XML file is read into a DataSet using “System.Boolean<\/a>” as DataType<\/a>.
\n
\nAfter a dataset is created, filled and written to an XML file using .WriteXML<\/a> the content might look like this:
\n
\n<\/code><\/div>\n
\n
<Systems>
\n<GUID>7f939d72-122e-4d9b-8bfb-3bfca94c813c<\/GUID>
\n<Name>LOCALHOST<\/Name>
\n<IPv4>127.0.0.1<\/IPv4>
\n<Memory_Size>0<\/Memory_Size>
\n<IsDataCollector>True<\/strong><\/IsDataCollector>
\n<IsLoadBot>False<\/strong><\/IsLoadBot>
\n<DataCollector_TimeOut>30<\/DataCollector_TimeOut>
\n<LoadBot_SessionStreams>0<\/LoadBot_SessionStreams>
\n<LoadBot_Slots>0<\/LoadBot_Slots>
\n<WOL>False<\/strong><\/WOL>
\n<\/Systems>
\n<Systems>
\n<GUID>cc126325-2eb9-4547-b99b-4c73a36f357e<\/GUID>
\n<Name>LoadBot01<\/Name>
\n<IPv4>172.17.2.72<\/IPv4>
\n<Memory_Size>49152<\/Memory_Size>
\n<OS_Family>Windows 7<\/OS_Family>
\n<IsDataCollector>False<\/strong><\/IsDataCollector>
\n<IsLoadBot>True<\/strong><\/IsLoadBot>
\n<DataCollector_TimeOut>30<\/DataCollector_TimeOut>
\n<LoadBot_SessionStreams>5<\/LoadBot_SessionStreams>
\n<LoadBot_Slots>500<\/LoadBot_Slots>
\n<GUID_RunAsAccount>f96312d1-7973-4448-9509-34b15eb78848<\/GUID_RunAsAccount>
\n<WOL>False<\/strong><\/WOL>
\n<\/Systems><\/div>\n<\/blockquote>\n
As you can see, both “True” and “False” starts with a capitol letter. This is what causes the problem, the .ReadXML<\/a> method expects “true” or “false” instead of “True” or “False”.
\nRemember, the content of the file is the result of the .WriteXML method, so is it a bug or a feature<\/a>?<\/div>\n
I don’t know, but the “solution” to the problem is quite simple. After saving an XML file using the .WriteXML method replace “>Truetrue<” and do the same for False.<\/div>\n
I usually use this code to write an XML file:<\/div>\n

\nFriend Sub WriteXML(ByVal Source As DataSet, ByVal Filename As String)
\nTry
\n'Define variables<\/code><\/div>\n

<\/p>\n

'Save dataset to XML
\nSource.WriteXml(Filename, XmlWriteMode.IgnoreSchema)<\/div>\n
'(re)open XML file
\nDim objFileStream As FileStream = New FileStream(Filename, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite)<\/div>\n
'Create streams
\nDim streamReader As New StreamReader(objFileStream)
\nDim streamWriter As New StreamWriter(objFileStream)<\/div>\n
'Read content of file
\nDim strContentOfXMLFile As String = streamReader.ReadToEnd<\/div>\n
'Replace boolean values
\nstrContentOfXMLFile = strContentOfXMLFile.Replace(\">TruetrueFalsefalse<\")<\/div>\n
'Reset position in filestream
\nobjFileStream.Position = 0<\/div>\n
'Reset lenght (in case content has changed)
\nobjFileStream.SetLength(strContentOfXMLFile.Length)<\/div>\n
'Write new content to XML file
\nstreamWriter.Write(strContentOfXMLFile)
\nstreamWriter.Flush()
\nstreamWriter.Close()<\/div>\n
'Close file
\nobjFileStream.Close()
\nCatch
\nEnd Try
\nEnd Sub<\/div>\n

<\/code><\/p>\n

Ingmar Verheij<\/div>","protected":false},"excerpt":{"rendered":"

This error is thrown when an XML file is read into a DataSet using “System.Boolean” as DataType.<\/p>","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[312],"tags":[237,238,239,240,241,242],"class_list":["post-1364","post","type-post","status-publish","format-standard","hentry","category-vb-net-scripting","tag-net","tag-dataset","tag-readxml","tag-the-string-true-is-not-a-valid-boolean-value","tag-vb-net","tag-writexml"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=1364"}],"version-history":[{"count":4,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1364\/revisions"}],"predecessor-version":[{"id":2452,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1364\/revisions\/2452"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=1364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=1364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=1364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}