📄 met_rs_open.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 Open 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">
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txtimg*/
google_ad_slot = "5330033957";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript" src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<noscript>
<a href="../default.asp" target="_blank"><img src="../banners/w6.gif" border="0" alt="W3Schools" /></a>
</noscript>
<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 Open 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 Open method opens a database element that gives you access to records in
a table, the results of a query, or to a
saved Recordset.
</p>
<p><b>Tip:</b> Always close the Recordset object after
using it, to free system resources. Set the Recordset object to Nothing to completely eliminate
it from memory.
</p>
<h3>Syntax
</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<td valign="top">
<pre>objRecordset.Open source,actconn,cursortyp,locktyp,opt</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">source </td>
<td valign="top"> Optional. Specifies a data source. The source parameter may be one of the following:
<ul>
<li>A URL</li>
<li>A relative/full file path name</li>
<li>A Command object</li>
<li>An SQL statement</li>
<li>A stored procedure</li>
<li>A table name</li>
</ul>
</td>
</tr>
<tr>
<td valign="top">actconn </td>
<td valign="top"> Optional. A connection string or a Connection object
</td>
</tr>
<tr>
<td valign="top">cursortyp </td>
<td valign="top"> Optional. A <a href="#CursorTypeEnum">CursorTypeEnum</a>
value that specifies the type of cursor to use when opening a Recordset
object.
Default is
adOpenForwardOnly
</td>
</tr>
<tr>
<td valign="top">locktyp </td>
<td valign="top"> Optional. A <a href="#LockTypeEnum">LockTypeEnum</a>
value that specifies the type of locking on a Recordset object. Default is
adLockReadOnly
</td>
</tr>
<tr>
<td valign="top">opt </td>
<td valign="top"> Optional. Specifies how to evaluate the source parameter if it
is not a Command object. Can be one or more <a href="#CommandTypeEnum"> CommandTypeEnum</a> or
<a href="#ExecuteOptionEnum"> ExecuteOptionEnum</a> values.
</td>
</tr>
</table>
<h3>Example</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<td valign="top">
Open an ADO Table Recordset:
<pre><%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Customers", conn
%></pre>
<p>Open an ADO SQL Recordset:</p>
<pre><%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn
%></pre>
</td>
</tr>
</table>
<br />
<hr />
<a name="CursorTypeEnum"><h3>CursorTypeEnum Values</h3></a>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top" align="left">
<th width="30%">Constant</th>
<th width="10%">Value</th>
<th width="60%">Description</th>
</tr>
<tr valign="top">
<td>adOpenUnspecified</td>
<td>-1</td>
<td>Unspecified type of cursor</td>
</tr>
<tr valign="top">
<td>adOpenForwardOnly</td>
<td>0</td>
<td>Default. A forward-only cursor. This improves performance when you need to make only one pass
through a Recordset</td>
</tr>
<tr valign="top">
<td>adOpenKeyset</td>
<td>1</td>
<td>A keyset cursor. Like a dynamic cursor, except that
you can't see records that other users add, although records that
other users delete are inaccessible from your Recordset. Data
changes by other users are still visible.</td>
</tr>
<tr valign="top">
<td>adOpenDynamic</td>
<td>2</td>
<td>A dynamic cursor.
Additions, changes, and deletions by other users are visible, and all
types of movement through the Recordset are allowed</td>
</tr>
<tr valign="top">
<td>adOpenStatic</td>
<td>3</td>
<td>A static cursor. A static copy of a set of records
that you can use to find data or generate reports. Additions, changes,
or deletions by other users are not visible.</td>
</tr>
</table>
<br />
<hr />
<a name="LockTypeEnum"><h3>LockTypeEnum Values</h3></a>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top" align="left">
<th width="30%">Constant</th>
<th width="10%">Value</th>
<th width="60%">Description</th>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -