110,533
社区成员
发帖
与我相关
我的任务
分享
DECLARE @x XML
SET @x = CONVERT(XML,'<items><item id="' + REPLACE(@BrandID, ',', '"/><item id="') + '"/></items>')
SELECT T.item.value('@id[1]','INT') AS link from @x.nodes('//items/item') T(item)
string szInputXml = "<TestDataXml><DataName>testing</DataName></TestDataXml>";
XmlTextReader reader = new XmlTextReader( new System.IO.StringReader( szInputXml ) );
reader.Read();
string inner = reader.ReadInnerXml();
string xmlString = @"<Test>
<X>
<D>1</D>
<D>2</D>
<D>3</D>
</X>
<Y>
<D>4</D>
<D>5</D>
<D>6</D>
</Y>
</Test>";
XmlTextReader reader = new XmlTextReader(new System.IO.StringReader(xmlString));
while (reader.Read())
{
if (reader.NodeType == XmlNodeType.Element)
{
if (reader.LocalName.Equals("Y"))
{
reader.Skip();
}
if (reader.LocalName.Equals("D"))
{
Console.WriteLine(reader.ReadString().ToString());
}
}
}
<Test>
<X>
<D>1</D>
<D>2</D>
<D>3</D>
</X>
<Y>
<D>4</D>
<D>5</D>
<D>6</D>
</Y>
</Test>
while (reader.Read())
{
if (reader.NodeType == XmlNodeType.Element&& reader.LocalName == "D")
{
list.Add(reader.ReadString().ToString());
}
}