在xml中的错误,并希望从xml读取每个节点
问题描述:
下面是myxml字符串,有人可以告诉我什么是在这个XML错误,此外,当我想加载和readxml它给我错误无效的字符串,因为我的UpgradeDBTemplate节点包含“”和花括号{}如何解决这个问题?在xml中的错误,并希望从xml读取每个节点
private string DBConfiguration =
@"<?xml version=""1.0""?>
<ArrayOfDB xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"">
<Database name=""mysql"">
<UpgradeScriptPath>/Data/upgradescript.xml.config</UpgradeScriptPath>
<DBBinPath>mysql</DBBinPath>
<UpgradeDBTemplate>""{0}"" -h{2} -uroot -p{1} < upgrade_db.txt </UpgradeDBTemplate>
</Database>
<Database name=""mssql"">
<UpgradeScriptPath> </UpgradeScriptPath>
<DBBinPath>SQLCMD</DBBinPath>
<UpgradeDBTemplate>""{0}"" -S {2} -U sa -p{1} -i upgrade_db.txt</UpgradeDBTemplate>
</Database>
</ArrayOfDB >
";
答
/// <summary>
/// Replaces invalid XML characters in a string with their valid XML equivalent.
/// </summary>
/// <param name="xmlString">The XML string.</param>
/// <returns>Valid Xml</returns>
public static string ReplaceInvalidXml(string xmlString)
{
return System.Security.SecurityElement.Escape(xmlString);
}
请告诉我们,失败的代码,以及刚刚字符串。 –
'
jbl