⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 met_rs_updatebatch.asp

📁 W3Schools tutorial..web designing
💻 ASP
字号:
🔍 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>

<title>ADO UpdateBatch Method</title>
 
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />

<meta name="Description" content="Free HTML XHTML CSS JavaScript DHTML XML DOM XSL XSLT RSS AJAX ASP ADO PHP SQL tutorials, references, examples for web building." />

<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />

<link rel="stylesheet" type="text/css" href="../stdtheme.css" />

<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>

</head>
<body>

<a name="top"></a>
<table cellpadding="0" cellspacing="0" width="100%" bgcolor="#808080">
<tr>
<td width="234" valign="top">
<a href="../default.htm"><img src="../images/w3default80.jpg" border="0" alt="W3Schools" /></a>
</td>
<th valign="middle" align="left" class="right">
<iframe style="background-color:#808080" src="../banners/bannerframe.asp@adpartner=mosso" height="90" width="728"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>

<br /></th>
</tr>
</table>

<table style="margin-left:1px" width="800px" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="137" class="content" valign="top"><br />
<a class="left" href="../default.asp" target="_top">
<img src="../images/homeicon.gif" border="0" alt="home" /></a>
<a class="left" href="../default.asp" target="_top">
<b>HOME</b></a>
<br /><br />
<b>ADO Tutorial</b><br />
<a class="left" target="_top" href="default.asp" >ADO HOME</a><br />
<a class="left" target="_top" href="ado_intro.asp" >ADO Intro</a><br />
<a class="left" target="_top" href="ado_connect.asp" >ADO Connect</a><br />
<a class="left" target="_top" href="ado_recordset.asp" >ADO Recordset</a><br />
<a class="left" target="_top" href="ado_display.asp" >ADO Display</a><br />
<a class="left" target="_top" href="ado_query.asp" >ADO Query</a><br />
<a class="left" target="_top" href="ado_sort.asp" >ADO Sort</a><br />
<a class="left" target="_top" href="ado_add.asp" >ADO Add</a><br />
<a class="left" target="_top" href="ado_update.asp" >ADO Update</a><br />
<a class="left" target="_top" href="ado_delete.asp" >ADO Delete</a><br />
<a class="left" target="_top" href="ado_demo.asp" >ADO Demo</a><br />
<a class="left" target="_top" href="ado_getstring.asp" >ADO Speed Up</a><br />
<br />
<b>ADO Objects</b><br />
<a class="left" target="_top" href="ado_ref_command.asp" >ADO Command</a><br />
<a class="left" target="_top" href="ado_ref_connection.asp" >ADO Connection</a><br />
<a class="left" target="_top" href="ado_ref_error.asp" >ADO Error</a><br />
<a class="left" target="_top" href="ado_ref_field.asp" >ADO Field</a><br />
<a class="left" target="_top" href="ado_ref_parameter.asp" >ADO Parameter</a><br />
<a class="left" target="_top" href="ado_ref_property.asp" >ADO Property</a><br />
<a class="left" target="_top" href="ado_ref_record.asp" >ADO Record</a><br />
<a class="left" target="_top" href="ado_ref_recordset.asp" >ADO Recordset</a><br />
<a class="left" target="_top" href="ado_ref_stream.asp" >ADO Stream</a><br />
<a class="left" target="_top" href="ado_datatypes.asp" >ADO DataTypes</a><br />
<br />
<a class="left" target="_top" href="ado_summary.asp" >ADO Summary</a><br />
<br />
<b>Examples</b><br />
<a class="left" target="_top" href="ado_examples.asp" >ADO Examples</a><br />
<br />
<b>Exam</b><br />
<a class="left" target="_top" href="../cert/default.asp" >ADO Exam</a><br />


<br />
<b>Selected Reading</b><br />
<a class="left" target="_top" href="../browsers/browsers_stats.asp">Web Statistics</a><br />
<a class="left" target="_top" href="../site/site_glossary.asp">Web Glossary</a><br />
<a class="left" target="_top" href="../hosting/default.asp">Web Hosting</a><br />
<a class="left" target="_top" href="../quality/default.asp">Web Quality</a><br /><br />
<a class="left" target="_top" href="../forum/default.asp">W3Schools Forum</a><br /><br />
<a class="left" target="_top" href="../about/about_helping.asp">Helping W3Schools</a><br /><br />
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*LeftLinkUnit*/
google_ad_slot = "4854527104";
google_ad_width = 120;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td>
<td valign="top">
<table style="border: 1px solid gray" width="100%" bgcolor="#FFFFFF" border="0" cellpadding="5" cellspacing="0">
<tr>
<td>


<h1>ADO UpdateBatch Method</h1>
<hr />
<a href="ado_ref_recordset.asp"><img class="navup" src="../images/up.gif" alt="Recordset Object Reference" border="0" /> Complete Recordset Object Reference</a>
<hr />
<p>The UpdateBatch method is used to save all changes in a Recordset to the database. This
method is used when you are working on a Recordset in batch update mode.
</p>

<p>If the save operation fails, a
run-time error occurs and the errors are stored in the Errors collection.
</p>

<p><b>Tip:</b> The CancelBatch method cancels all batch updates.
</p>

<p><b>Note:</b> Not all Recordset objects supports batch updating.
</p>

<h3>Syntax
</h3>

<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3"> 
  <tr>
    <td valign="top">
      <pre>bool=objRecordset.UpdateBatch affectrecords</pre>
    </td>
  </tr>
</table>
<br />
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3"> 
  <tr>
    <th align="left" valign="top" width="20%">Parameter</th>
    <th align="left" valign="top" width="80%">Description</th>
  </tr>  
  <tr>
    <td valign="top">affectrecords </td>
    <td valign="top">   Optional. An <a href="#affectenum"> AffectEnum</a> value
      that specifies which records this method will affect.
      <p><b>Note:</b> The value adAffectGroup will generate an error if there
      are no visible records in the Recordset</p>
    </td>
  </tr>
</table>
<br />
<hr />

<a name="affectenum"><h3>AffectEnum Values</h3></a>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3"> 
      <tr valign="top">
        <th align="left">Constant</th>
        <th align="left">Value</th>
        <th align="left">Description</th>
      </tr>
      <tr>
        <td>adAffectCurrent</td>
        <td>1</td>
        <td>Affects only the current record</td>
      </tr>
      <tr>
        <td>adAffectGroup</td>
        <td>2</td>
        <td>Affects only records that satisfy the Filter setting (Filter must be
          set to a FilterGroupEnum
          value or an array of Bookmarks)</td>
      </tr>
      <tr valign="top">
        <td>adAffectAll</td>
        <td>3</td>
        <td>Affects all records if there is no Filter. Affects only visible
          records in the current chapter if Filter is set to a string criteria.
          Affect all rows of the Recordset if Filter is set to a FilterGroupEnum
          value or an array of Bookmarks
        </td>
      </tr>
      <tr valign="top">
        <td>adAffectAllChapters</td>
        <td>4</td>
        <td>Affects all records in all child Recordset, including those hidden
          by a currently applied filter</td>
      </tr>
  </table>
<br />
<hr />
<a href="ado_ref_recordset.asp"><img class="navup" src="../images/up.gif" alt="Recordset Object Reference" border="0" /> Complete Recordset Object Reference</a>

<br />
<hr />

<!-- **** SPOTLIGHTS 1 **** -->

<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->

<table border="0" cellpadding="0" cellspacing="0">

<tr>
<td rowspan="3" align="left" valign="top">
<img src="../images/stylusstudio_01.gif" width="118" height="470" alt="" align="top" /></td>
<td colspan="2" align="left" valign="top">
<img src="../images/stylusstudio_02.gif" width="376" height="154" alt="" /></td>
<td rowspan="3" align="left" valign="top">
<img src="../images/stylusstudio_03.gif" width="6" height="470" alt="" /></td>
</tr>

<tr>
<td colspan="2" bgcolor="#e9eaec">
<table width="376" border="0" cellspacing="5" cellpadding="0">
<tr align="left" valign="top">
<td><strong>Learn XML with Stylus Studio XML Editor &#150; Free Download<br /></strong><br />
Stylus Studio provides tools for editing and debugging
<a style="color:#1675b2" href="../../www.stylusstudio.com/xml/editor/default.htm" target="_blank">XML</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/xslt.html" target="_blank">XSLT</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/xml_schema.html" target="_blank">XML Schema</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/dtd.html" target="_blank">DTD</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/xquery.html" target="_blank">XQuery</a>,
<a style="color:#1675b2" href="../../www.stylusstudio.com/web_services.html" target="_blank">Web Services</a>,and more!<br /><br />
<strong>Using Stylus Studio XML Tools You Can:<br /></strong>
<ul>
<li type="disc" style="margin-bottom:5px">
<a style="color:#1675b2" href="../../www.stylusstudio.com/convert_to_xml.html" target="_blank">
Convert any File to XML</a> (CSV, Tab-separated, HTML, EDI &amp; more.)</li>
<li type="disc" style="margin-bottom:5px">
<a style="color:#1675b2" href="../../www.stylusstudio.com/videos/ddxqdemo/datadirectxquery.html" target="_blank">
Access and Update any database as XML</a> (SQL Server, Oracle, MySQL &amp; more.)</li>
<li type="disc" style="margin-bottom:5px">
View, Edit, Parse, and Validate XML files.</li>
<li type="disc">
<a style="color:#1675b2" href="../../www.stylusstudio.com/xml/publishing.html" target="_blank">
Publish your data</a>, including <a style="color:#1675b2" href="../../www.stylusstudio.com/videos/publisher1/publisher1.html" target="_blank">XML to HTML</a>
or <a style="color:#1675b2" href="../../www.stylusstudio.com/xml_to_pdf.html" target="_blank">XML to PDF</a></li>
</ul>

<p>See why millions use Stylus Studio as their preferred XML tool. Download a
<a style="color:#1675b2" href="../../www.stylusstudio.com/xml_download.html" target="_blank">FREE TRIAL</a>
or watch an online <a style="color:#1675b2" href="../../www.stylusstudio.com/xml_videos.html" target="_blank">VIDEO DEMO</a> today!</p>
</td>
</tr>
</table>
</td>
</tr>

<tr>
<td align="left" valign="top">
<a href="../../www.stylusstudio.com/xml_download.html" target="_blank">
<img name="stylusstudio_05" src="../images/stylusstudio_05.gif" width="159" height="35" align="top" border="0" alt=""
onmouseover="this.src='../images/stylusstudio_05-over.gif'" onmouseout="this.src='../images/stylusstudio_05.gif'" />
</a></td>
<td align="left" valign="top">
<a href="../../www.stylusstudio.com/xml_videos.html" target="_blank">
<img name="stylusstudio_06" src="../images/stylusstudio_06.gif" width="217" height="35" align="top" border="0" alt=""
onmouseover="this.src='../images/stylusstudio_06-over.gif'" onmouseout="this.src='../images/stylusstudio_06.gif'" /></a></td>
</tr>
</table>
<hr />


<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />

<center>

<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*imgtxt*/
google_ad_slot = "8606855891";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

</center>
<hr />


<!-- **** END SPOTLIGHTS **** -->

</td></tr>

<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='met_rs_updatebatch.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>

</table>
</td></tr>
</table>
</td>


<td width="145" align="center" valign="top">




<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=ado" height="1850" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>

</td>
</tr></table>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -