110,535
社区成员
发帖
与我相关
我的任务
分享
<Id>1</Id><ProductName>电视</ProductName><MadeTime>1905-07-07T00:00:00+08:00</MadeTime><Price>3200</Price><UserName>Robin</UserName>
<Id>2</Id><ProductName>电脑</ProductName><MadeTime>1905-06-29T00:00:00+08:00</MadeTime><Price>7200</Price><UserName>zoray</UserName>
<Id>3</Id><ProductName>XBOX ONE</ProductName><MadeTime>1905-07-02T00:00:00+08:00</MadeTime><Price>5200</Price><UserName>James</UserName>
<Id>4</Id><ProductName>XBOX</ProductName><MadeTime>1905-07-04T00:00:00+08:00</MadeTime><Price>4200</Price><UserName>JERRY</UserName>
<Id>5</Id><ProductName>PSP4</ProductName><MadeTime>1905-07-03T00:00:00+08:00</MadeTime><Price>4200</Price><UserName>TOM</UserName>
<Id>6</Id><ProductName>PSP ONE</ProductName><MadeTime>1905-07-06T00:00:00+08:00</MadeTime><Price>3200</Price><UserName>TONY</UserName>
其中Id 为主键。
XmlDocument doc = new XmlDocument();
doc.Load("E:"+@"\新建文本文档.xml");
XmlNodeList node = doc.SelectNodes("/SystemConfig/Product");
for (int i = 0; i < node.Count; i++)
{
string id = node.Item(i).SelectSingleNode("/SystemConfig/Product/Id").InnerText;
string productName = node.Item(i).SelectSingleNode("/SystemConfig/Product/ProductName").InnerText;
string madeTime = node.Item(i).SelectSingleNode("/SystemConfig/Product/MadeTime").InnerText;
string price = node.Item(i).SelectSingleNode("/SystemConfig/Product/Price").InnerText;
string UserName = node.Item(i).SelectSingleNode("/SystemConfig/Product/UserName").InnerText;
//获取到值插入数据库
}
<Product>
<Id>1</Id><ProductName>电视</ProductName><MadeTime>1905-07-07T00:00:00+08:00</MadeTime><Price>3200</Price><UserName>Robin</UserName>
</Product>
<Product>
<Id>2</Id><ProductName>电脑</ProductName><MadeTime>1905-06-29T00:00:00+08:00</MadeTime><Price>7200</Price><UserName>zoray</UserName>
</Product>
<Product>
<Id>3</Id><ProductName>XBOX ONE</ProductName><MadeTime>1905-07-02T00:00:00+08:00</MadeTime><Price>5200</Price><UserName>James</UserName>
</Product>
<Product>
<Id>4</Id><ProductName>XBOX</ProductName><MadeTime>1905-07-04T00:00:00+08:00</MadeTime><Price>4200</Price><UserName>JERRY</UserName>
</Product>
<Product>
<Id>5</Id><ProductName>PSP4</ProductName><MadeTime>1905-07-03T00:00:00+08:00</MadeTime><Price>4200</Price><UserName>TOM</UserName>
</Product>
<Product>
<Id>6</Id><ProductName>PSP ONE</ProductName><MadeTime>1905-07-06T00:00:00+08:00</MadeTime><Price>3200</Price><UserName>TONY</UserName>
</Product>