asp.net c# 课件_C#_.NET_其他_其他下载-pudn.com

<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8"> <meta name="generator" content="pdf2htmlEX"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/626ef82b7b3701121407f7c1/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script> <script> try{ pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({}); }catch(e){} </script> <title></title> </head> <body> <div id="sidebar" style="display: none"> <div id="outline"> </div> </div> <div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626ef82b7b3701121407f7c1/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0"> <span class="_ _0"> </span> </div><div class="t m0 x2 h4 y3 ff2 fs1 fc0 sc0 ls0 ws0">第<span class="_ _1"> </span><span class="ff3">7<span class="_ _1"> </span></span><span class="sc1">章 <span class="_ _1"> </span></span><span class="ff3">ADO.NET<span class="_ _1"> </span></span><span class="sc1">操<span class="_ _2"></span>作<span class="_ _1"> </span></span><span class="ff3">SQL Server<span class="_ _1"> </span></span><span class="sc1">数据</span></div><div class="t m0 x3 h5 y4 ff2 fs1 fc0 sc1 ls0 ws0">库<span class="fs2 sc0"> </span></div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div> </body> </html>

<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626ef82b7b3701121407f7c1/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0"> <span class="_ _0"> </span> </div><div class="t m0 x4 h5 y5 ff2 fs2 fc0 sc0 ls0 ws0">内容提要</div><div class="t m0 x1 h6 y6 ff4 fs3 fc0 sc0 ls0 ws0">•</div><div class="t m0 x5 h7 y7 ff2 fs3 fc0 sc1 ls0 ws0">本<span class="_ _3"></span>章<span class="_ _3"></span>主<span class="_ _3"></span>要<span class="_ _3"></span>介<span class="_ _4"></span>绍<span class="_ _1"> </span><span class="ff3 sc0">SQL <span class="_ _3"></span>Server2000<span class="_ _5"> </span></span>的<span class="_ _3"></span>基<span class="_ _3"></span>本<span class="_ _3"></span>使<span class="_ _3"></span>用<span class="_ _3"></span>。<span class="_ _4"></span>介</div><div class="t m0 x5 h7 y8 ff2 fs3 fc0 sc0 ls0 ws0">绍<span class="_ _6"> </span><span class="ff3">SQL Server2000<span class="_ _6"> </span></span><span class="sc1">集成开发环境的使用。</span></div><div class="t m0 x1 h6 y9 ff4 fs3 fc0 sc0 ls0 ws0">•</div><div class="t m0 x5 h7 ya ff2 fs3 fc0 sc1 ls0 ws0">介<span class="_ _3"></span>绍<span class="_ _3"></span>了<span class="_ _3"></span>如<span class="_ _3"></span>何<span class="_ _4"></span>在<span class="_ _1"> </span><span class="ff3 sc0">SQL <span class="_ _3"></span>Server2000<span class="_ _5"> </span></span>中<span class="_ _3"></span>使<span class="_ _3"></span>用<span class="_ _3"></span>查<span class="_ _3"></span>询<span class="_ _3"></span>分<span class="_ _4"></span>析</div><div class="t m0 x5 h7 yb ff2 fs3 fc0 sc1 ls0 ws0">器建立数据库<span class="_ _7"></span>和数据库表，</div><div class="t m0 x1 h6 yc ff4 fs3 fc0 sc0 ls0 ws0">•</div><div class="t m0 x5 h7 yd ff2 fs3 fc0 sc1 ls0 ws0">如何使用<span class="_ _6"> </span><span class="ff3 sc0">A<span class="_ _7"></span>DO.NET<span class="_ _6"> </span><span class="ff2 sc1">操作数据库表。</span></span></div><div class="t m0 x1 h6 ye ff4 fs3 fc0 sc0 ls0 ws0">•</div><div class="t m0 x5 h7 yf ff2 fs3 fc0 sc1 ls0 ws0">重<span class="_ _8"> </span>点<span class="_ _8"> </span>介<span class="_ _8"> </span>绍<span class="_ _8"> </span>如<span class="_ _8"> </span>何<span class="_ _8"> </span>使<span class="_ _8"> </span>用<span class="_ _9"> </span><span class="ff3 sc0">ADO.NE<span class="_ _7"></span>T<span class="_ _9"> </span><span class="ff2 sc1">的<span class="_ _8"> </span>命<span class="_ _8"> </span>名<span class="_ _8"> </span>空</span></span></div><div class="t m0 x5 h7 y10 ff2 fs3 fc0 sc1 ls0 ws0">间<span class="_ _a"> </span>“<span class="_ _b"> </span><span class="ff3 sc0">System.Data.SqlClien<span class="_ _7"></span>t”<span class="_ _8"> </span><span class="ff2 sc1">操<span class="_ _a"> </span>作<span class="_ _b"> </span></span>SQL <span class="_ _a"> </span>Server</span></div><div class="t m0 x5 h7 y11 ff2 fs3 fc0 sc1 ls0 ws0">的存储过程。</div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>

<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626ef82b7b3701121407f7c1/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0"> <span class="_ _0"> </span> </div><div class="t m0 x6 h5 y5 ff4 fs2 fc0 sc0 ls0 ws0">SQL Server<span class="_ _b"> </span><span class="ff2">简<span class="_ _2"></span>介 </span></div><div class="t m0 x1 h6 y6 ff4 fs3 fc0 sc0 ls0 ws0">•</div><div class="t m0 x5 h7 y7 ff2 fs3 fc0 sc0 ls0 ws0">与<span class="_ _6"> </span><span class="ff4">Access<span class="_ _6"> </span></span>相比较，它具有更好的应<span class="_ _7"></span>用特征，如</div><div class="t m0 x5 h7 y8 ff2 fs3 fc0 sc0 ls0 ws0">下所示。</div><div class="t m0 x7 h8 y12 ff4 fs4 fc0 sc0 ls0 ws0">–</div><div class="t m0 x8 h9 y13 ff2 fs4 fc0 sc0 ls0 ws0">（<span class="_ _c"> </span><span class="ff4">1<span class="_ _c"> </span></span>）支持企业级运算、支持<span class="_ _c"> </span><span class="ff4">C/S<span class="_ _c"> </span></span>模型、更好的性能</div><div class="t m0 x8 h9 y14 ff2 fs4 fc0 sc0 ls0 ws0">和更方便的操作。</div><div class="t m0 x7 h8 y15 ff4 fs4 fc0 sc0 ls0 ws0">–</div><div class="t m0 x8 h9 y16 ff2 fs4 fc0 sc0 ls0 ws0">（<span class="_ _c"> </span><span class="ff4">2<span class="_ _c"> </span></span>）功能增强：海量数据存储、数据复制、数据转</div><div class="t m0 x8 h9 y17 ff2 fs4 fc0 sc0 ls0 ws0">换服务、分布式事务、全文检索。</div><div class="t m0 x7 h8 y18 ff4 fs4 fc0 sc0 ls0 ws0">–</div><div class="t m0 x8 h9 y19 ff2 fs4 fc0 sc0 ls0 ws0">（<span class="_ _c"> </span><span class="ff4">3<span class="_ _c"> </span></span>）支持多种协议（<span class="_ _c"> </span><span class="ff4">TCP/IP<span class="_ _c"> </span></span>、<span class="_ _c"> </span><span class="ff4">NETBEUI<span class="_ _c"> </span></span>）和支持</div><div class="t m0 x8 h9 y1a ff2 fs4 fc0 sc0 ls0 ws0">分布式计算，分布式计算模型。</div><div class="t m0 x7 h8 y1b ff4 fs4 fc0 sc0 ls0 ws0">–</div><div class="t m0 x8 h9 y1c ff2 fs4 fc0 sc0 ls0 ws0">（<span class="_ _c"> </span><span class="ff4">4<span class="_ _c"> </span></span>）<span class="_ _c"> </span><span class="ff4">ANSI/92<span class="_ _c"> </span></span>标准兼容并进行<span class="_ _c"> </span><span class="ff4">T-SQ<span class="_ _2"></span>L<span class="_ _c"> </span></span>（<span class="_ _c"> </span><span class="ff4">Transact </span></div><div class="t m0 x8 h9 y1d ff4 fs4 fc0 sc0 ls0 ws0">SQL<span class="_ _c"> </span><span class="ff2">，事务<span class="_ _c"> </span></span>SQL<span class="_ _c"> </span><span class="ff2">语言）的增强。</span></div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>

<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626ef82b7b3701121407f7c1/bg4.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0"> <span class="_ _0"> </span> </div><div class="t m0 x7 h5 y5 ff4 fs2 fc0 sc0 ls0 ws0">SQL Server<span class="_ _b"> </span><span class="ff2">的<span class="_ _2"></span>集成环境介绍 </span></div><div class="t m0 x1 ha y1e ff4 fs1 fc0 sc0 ls0 ws0">•</div><div class="t m0 x5 h4 y1f ff4 fs1 fc0 sc0 ls0 ws0">SQL Server2000<span class="_ _1"> </span><span class="ff2">提供强大的</span></div><div class="t m0 x5 h4 y20 ff4 fs1 fc0 sc0 ls0 ws0">GUI<span class="_ _1"> </span><span class="ff2">（<span class="_ _1"> </span></span>Graphic User Interface<span class="_ _5"> </span><span class="ff2">，图形用户</span></div><div class="t m0 x5 h4 y21 ff2 fs1 fc0 sc0 ls0 ws0">接口）界面，用户可以<span class="_ _2"></span>直接通过界面或者</div><div class="t m0 x5 h4 y22 ff2 fs1 fc0 sc0 ls0 ws0">通过<span class="_ _1"> </span><span class="ff4">T-SQL<span class="_ _1"> </span></span>语句操<span class="_ _2"></span>作数据库。</div><div class="t m0 x1 ha y23 ff4 fs1 fc0 sc0 ls0 ws0">•</div><div class="t m0 x5 h4 y24 ff2 fs1 fc0 sc0 ls0 ws0">常用的图形界面包括：<span class="_ _5"> </span><span class="ff4">SQL Server<span class="_ _1"> </span></span>服务<span class="_ _2"></span>管</div><div class="t m0 x5 h4 y25 ff2 fs1 fc0 sc0 ls0 ws0">理器、企业管理器、查<span class="_ _2"></span>询分析器、事件查</div><div class="t m0 x5 h4 y26 ff2 fs1 fc0 sc0 ls0 ws0">看器和联机帮助，等等<span class="_ _2"></span>。</div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>

<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626ef82b7b3701121407f7c1/bg5.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0"> <span class="_ _0"> </span> </div><div class="t m0 x9 h5 y5 ff4 fs2 fc0 sc0 ls0 ws0"> SQL<span class="_ _b"> </span><span class="ff2">服务管理器 </span></div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>