<?xml version="1.0" encoding="GB2312" ?>
<recordset table="SN_APZY_DAT" ddnpid="64313288">
<record>
<field name="Info_ID">12000000036000110100200511027147</field>
<field name="Info_Group">种植业</field>
<field name="Info_Sort">油料作物</field>
<field name="Info_Division"></field>
<field name="Info_Section"></field>
<field name="Info_Unit">大豆</field>
<field name="Operation_Phase">病虫草敌害防治</field>
<field name="Operation_Section"></field>
<field name="question">总述大豆病虫害综合防治技术要点?</field>
<field name="Answer">大豆病虫害综合防治技术要点</field>
<field name="Info_Source">900000</field>
<field name="Info_Adaptation">北京;天津;</field>
<field name="Load_Date">2005-11-02 15:07:34</field>
<field name="Voice_Service_Number">246423</field>
<field name="IsNew">true</field>
</record>
<record>
<field name="Info_ID">12000000036000110100200511027644</field>
<field name="Info_Group">种植业</field>
<field name="Info_Sort">油料作物</field>
<field name="Info_Division"></field>
<field name="Info_Section"></field>
<field name="Info_Unit">大豆</field>
<field name="Operation_Phase">病虫草敌害防治</field>
<field name="Operation_Section"></field>
<field name="question">如何防治东北大黑金龟子?</field>
<field name="Answer">东北大黑金龟子的防治方法:一、农业防治。</field>
<field name="Info_Source">900000</field>
<field name="Info_Adaptation">北京;天津;河北;</field>
<field name="Load_Date">2005-11-02 15:07:35</field>
<field name="Voice_Service_Number">246410</field>
<field name="IsNew">true</field>
</record></recordset>
用c#吧上面的xml中数据读取出来,拼成语句,属性name值是数据库字段,文本时值例如:组成 Info_ID='12000000036000110100200511027644',Info_Sort=‘油料作物’
<recordset table="SN_APZY_DAT" ddnpid="64313288">
<record>
<field name="Info_ID">12000000036000110100200511027147</field>
<field name="Info_Group">种植业</field>
<field name="Info_Sort">油料作物</field>
<field name="Info_Division"></field>
<field name="Info_Section"></field>
<field name="Info_Unit">大豆</field>
<field name="Operation_Phase">病虫草敌害防治</field>
<field name="Operation_Section"></field>
<field name="question">总述大豆病虫害综合防治技术要点?</field>
<field name="Answer">大豆病虫害综合防治技术要点</field>
<field name="Info_Source">900000</field>
<field name="Info_Adaptation">北京;天津;</field>
<field name="Load_Date">2005-11-02 15:07:34</field>
<field name="Voice_Service_Number">246423</field>
<field name="IsNew">true</field>
</record>
<record>
<field name="Info_ID">12000000036000110100200511027644</field>
<field name="Info_Group">种植业</field>
<field name="Info_Sort">油料作物</field>
<field name="Info_Division"></field>
<field name="Info_Section"></field>
<field name="Info_Unit">大豆</field>
<field name="Operation_Phase">病虫草敌害防治</field>
<field name="Operation_Section"></field>
<field name="question">如何防治东北大黑金龟子?</field>
<field name="Answer">东北大黑金龟子的防治方法:一、农业防治。</field>
<field name="Info_Source">900000</field>
<field name="Info_Adaptation">北京;天津;河北;</field>
<field name="Load_Date">2005-11-02 15:07:35</field>
<field name="Voice_Service_Number">246410</field>
<field name="IsNew">true</field>
</record></recordset>
用c#吧上面的xml中数据读取出来,拼成语句,属性name值是数据库字段,文本时值例如:组成 Info_ID='12000000036000110100200511027644',Info_Sort=‘油料作物’
解决方案 »
- 如何读取excel的sheet个数
- C#调用C++ DLL中的函数(WINDOWS MOBILE 6)
- ASP.NET2.0中WebBrowser控件中如何向Radio元素赋值为checked
- 索引超出了数组界限,急!!!!!
- .net怎么样把握他的核心
- 请教,如何使数值类型的小数点后变成最大长度?
- 求正则表达式?琼AB1234、琼A12345、琼ABC123等类似车牌号的?
- Socket通讯问题,麻烦各位大虾们帮忙解答一下!
- 最简单的问题~~!~!~
- 字符串处理的一个问题
- www.godaddy.com上配制access数据库发生Exception Details: System.Data.OleDb.OleDbException
- 用 NSIS 打包 C#程序 的相关问题。
{ string str = "";
XmlDocument doc = new XmlDocument();
doc.Load(xmlPath); XmlNodeList nodeList = doc.DocumentElement.ChildNodes;
foreach (XmlNode node in nodeList)
{
XmlNodeList childNodeList = node.ChildNodes;
foreach (XmlNode childNode in childNodeList)
{
str += childNode.Attributes["name"].Value+"="+childNode.InnerText+"\n";
}
}
Console.WriteLine(str);
}
我刚开业用了类似的方法,但读取比较慢,用你这个做也慢,我吧文件变小(原xml大小2.24M)就快了。接分。也给关注兄弟们分了点。