100165651.htm
来自「C#高级编程(第三版),顶死你们。。 。up」· HTM 代码 · 共 181 行 · 第 1/3 页
HTM
181 行
<!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.3 读写DiffGram
</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="100165651.htm">
23.8.3 读写DiffGram
</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='100165651.htm'><font color='red'>23.8.3 读写DiffGram</font></a></h1>
<div id="divRelateNode" style="padding-left: 2px">
<div style='float:left;width:49%'>·<a href='100165648.htm'>23.8.1 将ADO.NET数据转换为XML文档(1)</a></div><div style='float:right;width:49%'>·<a href='100165649.htm'>23.8.1 将ADO.NET数据转换为XML文档(2)</a></div><div style='float:left;width:49%'>·<a href='100165650.htm'>23.8.2 把XML文档转换为 ADO.NET数据</a></div><div style='float:right;width:49%'>·<a href='100165652.htm'>23.9 在XML中串行化对象</a></div><div style='float:left;width:49%'>·<a href='100165653.htm'>23.10 小结</a></div><div style='float:right;width:49%'>·<a href='100165679.htm'>25.1 ASP.NET概述</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.3 </span><span style="FONT-FAMILY: 黑体">读写</span><span lang="EN-US">DiffGram</span></h3>
<p class="MsoNormal"><a ftel="DiffGrams"><span lang="EN-US">DiffGram</span></a><span style="FONT-FAMILY: 宋体">是包含数据在编辑对话前后的</span><span lang="EN-US">XML</span><span style="FONT-FAMILY: 宋体">文档。它可以包含修改、增加和删除数据的任何组合。</span><span lang="EN-US">DiffGram</span><span style="FONT-FAMILY: 宋体">可以用作审计跟踪或用于提交</span><span lang="EN-US">/</span><span style="FONT-FAMILY: 宋体">回滚</span><span lang="EN-US">(commit/rollback)</span><span style="FONT-FAMILY: 宋体">过程。目前的大多数</span><span lang="EN-US">DBMS</span><span style="FONT-FAMILY: 宋体">系统都内置了</span><span lang="EN-US">DiffGram</span><span style="FONT-FAMILY: 宋体">，但如果使用一个没有这些功能的</span><span lang="EN-US">DBMS</span><span style="FONT-FAMILY: 宋体">，或者</span><span lang="EN-US">XML</span><span style="FONT-FAMILY: 宋体">是数据库，且用户没有</span><span lang="EN-US">DBMS</span><span style="FONT-FAMILY: 宋体">，就可以自己执行提交</span><span lang="EN-US">/</span><span style="FONT-FAMILY: 宋体">重新运行过程。</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 宋体">下面的代码显示了如何创建一个</span><span lang="EN-US">DiffGram</span><span style="FONT-FAMILY: 宋体">，以及如何从</span><span lang="EN-US">DiffGram:pwd </span><span style="FONT-FAMILY: 宋体">中创建一个</span><span lang="EN-US">DataSet(</span><span style="FONT-FAMILY: 宋体">这段代码在</span><span lang="EN-US">ADOSample6</span><span style="FONT-FAMILY: 宋体">文件夹中</span><span lang="EN-US">)</span><span style="FONT-FAMILY: 宋体">。</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"> ds</span><span style="FONT-FAMILY: 宋体">，一个新的</span><span lang="EN-US">SqlConnection</span><span style="FONT-FAMILY: 宋体">对象</span><span lang="EN-US"> conn</span><span style="FONT-FAMILY: 宋体">和一个新的</span><span lang="EN-US">SqlDataAdapter</span><span style="FONT-FAMILY: 宋体">对象</span><span lang="EN-US"> da</span><span style="FONT-FAMILY: 宋体">。连接到数据库上，选择</span><span lang="EN-US">Products</span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: -0.1pt">表中的所有行，创建一个新的</span><span lang="EN-US" style="LETTER-SPACING: -0.1pt">DataTable</span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: -0.1pt">，命名为</span><span lang="EN-US" style="LETTER-SPACING: -0.1pt">products</span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: -0.1pt">，把数据库中的数据加载到</span><span lang="EN-US" style="LETTER-SPACING: -0.1pt">DataSet</span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: -0.1pt">中：</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"> //new DataSet</span></p>
<p class="a6" style="MARGIN-LEFT: 21.45pt; LINE-HEIGHT: 15pt; 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"> //Make connection and load products rows</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> SqlConnection conn=new SqlConnection</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> (@"server=GLYNNJ</span><span lang="EN-US" style="FONT-FAMILY: 'Baskerville BE Regular'">_</span><span lang="EN-US">CS\NetSDK;uid=sa;pwd=;database=northwind");</span></p>
<p class="2" style="MARGIN-LEFT: 21.45pt; FTEL: 18.45pt"><span lang="EN-US"> SqlDataAdapter da=new SqlDataAdapter("SELECT * FROM products",conn);</span></p>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?