100165650.htm
来自「C#高级编程(第三版),顶死你们。。 。up」· HTM 代码 · 共 199 行 · 第 1/2 页
HTM
199 行
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>
23.8.2 把XML文档转换为 ADO.NET数据
</title></head>
<body>
<div class="area">
<div class="col1">
<div class="lineBlue">
</div>
<!-- title -->
<div class="arcTitle">
<h1>
<a href="../16">
C#高级编程（第3版）
</a>
</h1>
<div style="text-align: center; font-size: 15px">
<a href="100165650.htm">
23.8.2 把XML文档转换为 ADO.NET数据
</a>
</div>
<div style="text-align: center; font-size: 15px">
<a class="url" href="../../default.htm">http://book.csdn.net/</a>
2006-10-13 14:41:00
</div>
<div style="margin: 0px auto; width: 700px; border: solid 1px #0b5f98;">
<div style="float: left; width: 16px; background-color: #0b5f98; color: White; padding: 1px;">
图书导读
</div>
<div style="float: right; width: 670px; text-align: left; line-height: 16pt; padding-left: 2px">
<!--导读-->
<h1 id="divCurrentNode" style="color: #b83507; width: 100%; text-align: left; font-size: 12px; padding-left: 2px">当前章节:<a href='100165650.htm'><font color='red'>23.8.2 把XML文档转换为 ADO.NET数据</font></a></h1>
<div id="divRelateNode" style="padding-left: 2px">
<div style='float:left;width:49%'>·<a href='100165647.htm'>23.8 XML和ADO.NET</a></div><div style='float:right;width:49%'>·<a href='100165648.htm'>23.8.1 将ADO.NET数据转换为XML文档(1)</a></div><div style='float:left;width:49%'>·<a href='100165649.htm'>23.8.1 将ADO.NET数据转换为XML文档(2)</a></div><div style='float:right;width:49%'>·<a href='100165651.htm'>23.8.3 读写DiffGram</a></div><div style='float:left;width:49%'>·<a href='100165652.htm'>23.9 在XML中串行化对象</a></div><div style='float:right;width:49%'>·<a href='100165653.htm'>23.10 小结</a></div></div>
</div>
</div>
</div>
<!-- main -->
<div id="main">
<div id="text">
<div id="csdn_zhaig_ad_yahoo_2"></div>
<link href="css.css" rel="stylesheet" type="text/css" /><h3 style="MARGIN-TOP: 8.15pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FTEL: 8.15pt"><span lang="EN-US">23.8.2 </span><span style="FONT-FAMILY: 黑体">把</span><span lang="EN-US">XML</span><span style="FONT-FAMILY: 黑体">文档转换为</span><span lang="EN-US"> ADO.NET</span><span style="FONT-FAMILY: 黑体">数据</span></h3>
<p class="MsoNormal"><span style="FONT-FAMILY: 宋体">现在有一个</span><span lang="EN-US">XML</span><span style="FONT-FAMILY: 宋体">文档，准备把它转换为</span><span lang="EN-US">ADO.NET</span><span style="FONT-FAMILY: 宋体">的</span><span lang="EN-US">DataSet</span><span style="FONT-FAMILY: 宋体">。这样就可以把</span><span lang="EN-US">XML</span><span style="FONT-FAMILY: 宋体">加载到数据库中，或者把数据绑定到</span><span lang="EN-US">.NET</span><span style="FONT-FAMILY: 宋体">数据控件上，例如</span><span lang="EN-US">DataGrid</span><span style="FONT-FAMILY: 宋体">。此时可以把</span><span lang="EN-US">XML</span><span style="FONT-FAMILY: 宋体">文档用作数据库，完全消除数据库的系统开销。如果数据比较少，这是完全有可能的。看看下面这些代码</span><span lang="EN-US">(</span><span style="FONT-FAMILY: 宋体">位于</span><span lang="EN-US">ADOSample5</span><span style="FONT-FAMILY: 宋体">中</span><span lang="EN-US">)</span><span style="FONT-FAMILY: 宋体">：</span></p>
<p class="a6" style="MARGIN-TOP: 8.15pt; MARGIN-LEFT: 21.45pt; MARGIN-RIGHT: 0cm; FTEL: 18.45pt"><span lang="EN-US">private void button1</span><span lang="EN-US" style="FONT-FAMILY: 'Baskerville BE Regular'">_</span><span lang="EN-US">Click(object sender, System.EventArgs e)</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US">{</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> //create a new DataSet</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> DataSet ds=new DataSet("XMLProducts");</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> //read in the XML document to the Dataset</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> ds.ReadXml("..\\..\\..\\prod.xml");</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> //load data into grid</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> dataGrid1.DataSource=ds;</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> dataGrid1.DataMember="products";</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> //create the new XmlDataDocument</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> doc=new XmlDataDocument(ds);</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> //load the product names into the listbox</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> XmlNodeList nodeLst=doc.SelectNodes("//ProductName");</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> </span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> foreach(XmlNode nd in nodeLst)</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> listBox1.Items.Add(nd.InnerXml);</span></p>
<p class="a6" style="MARGIN-TOP: 0cm; MARGIN-LEFT: 21.45pt; MARGIN-RIGHT: 0cm; FTEL: 18.45pt"><span lang="EN-US">}</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 宋体">这很简单。实例化一个新</span><span lang="EN-US">DataSet</span><span style="FONT-FAMILY: 宋体">对象，调用</span><span lang="EN-US">ReadXml</span><span style="FONT-FAMILY: 宋体">方法，把</span><span lang="EN-US">XML</span><span style="FONT-FAMILY: 宋体">放在</span><span lang="EN-US">DataSet</span><span style="FONT-FAMILY: 宋体">的一个</span><span lang="EN-US">DataTable</span><span style="FONT-FAMILY: 宋体">中。与</span><span lang="EN-US">WriteXml</span><span style="FONT-FAMILY: 宋体">方法一样，</span><span lang="EN-US">ReadXml</span><span style="FONT-FAMILY: 宋体">的参数是</span><span lang="EN-US">XmlReadMode</span><span style="FONT-FAMILY: 宋体">。</span><span lang="EN-US">ReadXml</span><span style="FONT-FAMILY: 宋体">还可以使用</span><span lang="EN-US">XmlReadMode</span><span style="FONT-FAMILY: 宋体">中的更多选项</span><span lang="EN-US">(</span><span style="FONT-FAMILY: 宋体">如表</span><span lang="EN-US">23-9</span><span style="FONT-FAMILY: 宋体">所示</span><span lang="EN-US">)</span><span style="FONT-FAMILY: 宋体">。</span></p>
<p class="a5" style="MARGIN-TOP: 8.15pt"><span style="FONT-FAMILY: 黑体">表</span> <span lang="EN-US"> 23-9</span></p>
<table class="MsoNormalTable" style="MARGIN-LEFT: 20.2pt; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-COLLAPSE: collapse; BORDER-BOTTOM-STYLE: none" cellspacing="0" cellpadding="0" border="1">
<tbody>
<tr>
<td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BORDER-LEFT-WIDTH: 1pt; BORDER-LEFT-COLOR: windowtext; PADDING-BOTTOM: 0cm; WIDTH: 86.85pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid" valign="top" width="116">
<p class="a2"><span style="FONT-FAMILY: 黑体">选</span><span lang="EN-US"> </span><span style="FONT-FAMILY: 黑体">项</span></p>
</td>
<td style="PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; WIDTH: 343.15pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none" valign="top" width="458">
<p class="a2"><span style="FONT-FAMILY: 黑体">说</span><span lang="EN-US"> </span><span style="FONT-FAMILY: 黑体">明</span></p>
</td>
</tr>
<tr>
<td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; WIDTH: 86.85pt; BORDER-TOP-STYLE: none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT-STYLE: none" valign="top" width="116">
<p class="a4" style="MARGIN-LEFT: 10.7pt"><span lang="EN-US">Auto</span></p>
</td>
<td style="PADDING-RIGHT: 5.4pt; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; WIDTH: 343.15pt; BORDER-TOP-STYLE: none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none" valign="top" width="458">
<p class="a4" style="MARGIN-LEFT: 10.7pt"><span style="FONT-FAMILY: 宋体">把</span><span lang="EN-US">XmlReadMode</span><span style="FONT-FAMILY: 宋体">设置为最合适的值。如果数据是</span><span lang="EN-US">DiffGram</span><span style="FONT-FAMILY: 宋体">格式，就选择</span><span lang="EN-US">DiffGram</span><span style="FONT-FAMILY: 宋体">；如果已经读取了模式，或者检测到某个内联模式，就选择</span><span lang="EN-US">ReadSchema</span><span style="FONT-FAMILY: 宋体">。如果没有为</span><span lang="EN-US">DataSet</span><span style="FONT-FAMILY: 宋体">指定模式，也没有检测到内联模式，就选择</span><span lang="EN-US">IgnoreSchema</span></p>
</td>
</tr>
<tr>
<td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; WIDTH: 86.85pt; BORDER-TOP-STYLE: none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT-STYLE: none" valign="top" width="116">
<p class="a4" style="MARGIN-LEFT: 10.7pt"><span lang="EN-US">DiffGram</span></p>
</td>
<td style="PADDING-RIGHT: 5.4pt; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; WIDTH: 343.15pt; BORDER-TOP-STYLE: none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none" valign="top" width="458">
<p class="a4" style="MARGIN-LEFT: 10.7pt"><span style="FONT-FAMILY: 宋体">读取</span><span lang="EN-US">DiffGram</span><span style="FONT-FAMILY: 宋体">，把变化应用到</span><span lang="EN-US">DataSet</span><span style="FONT-FAMILY: 宋体">上。本章的后面介绍</span><span lang="EN-US"> DiffGrams </span></p>
</td>
</tr>
<tr>
<td style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; WIDTH: 86.85pt; BORDER-TOP-STYLE: none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT-STYLE: none" valign="top" width="116">
<p class="a4" style="MARGIN-LEFT: 10.7pt"><span lang="EN-US">Fragment</span></p>
</td>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?