XML导入到ACCESS数据库代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】 XML导入到ACCESS数据库
作者:三角猫 / 发布于2011/7/20/ 904
<div>假设有如下的XML文件：

<?xml version="1.0" encoding="utf-8" ?>
<users>
 <user code="lm">
 <name>黎明</name>
 <sex>male</sex>
 <age>28</age>
 </user>
 <user code="sq">
 <name>舒淇</name>
 <sex>female</sex>
 <age>27</age>
 </user>
</users></div>
<div></div>
<div>要将上面的XML内容，导入的一个ACCESS数据库中的userinfo表，ACCESS的userinfo表的结构如下：</div>
<div></div>
<div><span style="color: green">//请将ACCESS数据库的路径替换为实际的路径
</span><span style="color: blue">using </span>(<span style="color: rgb(43,145,175)">OleDbConnection </span>cn = <span style="color: blue">new </span><span style="color: rgb(43,145,175)">OleDbConnection</span>(<span style="color: rgb(163,21,21)">@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=d:\demo.mdb"</span>))
{
 cn.Open();
 <span style="color: blue">using </span>(<span style="color: rgb(43,145,175)">OleDbCommand </span>cmd = <span style="color: blue">new </span><span style="color: rgb(43,145,175)">OleDbCommand</span>())
 {
 cmd.Connection = cn;
 cmd.CommandType = <span style="color: rgb(43,145,175)">CommandType</span>.Text;

 <span style="color: rgb(43,145,175)">XmlDocument </span>xml = <span style="color: blue">new </span><span style="color: rgb(43,145,175)">XmlDocument</span>();
 <span style="color: green">//请将XML的路径替换为实际的路径
 </span>xml.Load(<span style="color: rgb(163,21,21)">@"d:\demo.xml"</span>);

 <span style="color: green">//取得所有的user
 </span><span style="color: rgb(43,145,175)">XmlNodeList </span>xn = xml.GetElementsByTagName(<span style="color: rgb(163,21,21)">"user"</span>);

 <span style="color: green">//遍历所有的user
 </span><span style="color: blue">foreach </span>(<span style="color: rgb(43,145,175)">XmlElement </span>xe <span style="color: blue">in </span>xn)
 {
 cmd.CommandText = <span style="color: blue">string</span>.Format(<span style="color: rgb(163,21,21)">"INSERT INTO userinfo([UserCode],[UserName],[UserSex],[UserAge]) VALUES ('{0}', '{1}', '{2}', {3})"</span>,
 xe.GetAttribute(<span style="color: rgb(163,21,21)">"code"</span>), <span style="color: green">//取得code
 </span>xe.ChildNodes[0].InnerText, <span style="color: green">//取得Name
 </span>xe.ChildNodes[1].InnerText, <span style="color: green">//取得Sex
 </span>xe.ChildNodes[2].InnerText <span style="color: green">//取得Age
 </span>);

 <span style="color: green">//插入数据
 </span>cmd.ExecuteNonQuery();
 }
 }
}
<div></div>
试试其它关键字
　XML导入到ACCESS　
同语言下
可能有用的
三角猫贡献的其它代码(21)