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

📄 met_comm_createparameter.asp

📁 W3Schools tutorial..web designing
💻 ASP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<!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 CreateParameter 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 CreateParameter Method</h1>
<hr />
<a href="ado_ref_command.asp"><img class="navup" src="../images/up.gif" alt="Command Object Reference" border="0" /> Complete Command Object Reference</a>
<hr />
<p>The CreateParameter method creates and returns a Parameter object containing
the specified
properties like name, type, direction, size, and value.
</p>

<p><b>Note:</b> This method does not automatically add the new Parameter to the collection.
To add the Parameter to the Parameters Collection, use the Append property.
</p>

<h3>Syntax</h3>

<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3"> 
  <tr>
    <td valign="top">
      <pre>Set objparameter=objcommand.CreateParameter
(name,type,direction,size,value)</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">name </td>
    <td valign="top">Optional. The name of the Parameter object.</td>
  </tr>
  <tr>
    <td valign="top">type </td>
    <td valign="top">Optional. One of the <a href="#datatypeenum">DataTypeEnum</a> 
      constants that specifies the data type for the Parameter object. Default is adEmpty. If you choose a variable-length data type, you will also need to
      specify the Size parameter or the Size property. If you specify adDecimal or adNumeric data type, you
      must also set the NumericScale and the Precision properties of the Parameter
      object.      
    </td>
  </tr>
  <tr>
    <td valign="top">direction </td>
    <td valign="top"> Optional. One of the <a href="#parameterdirenum"> ParameterDirectionEnum</a> constants that defines the direction
      of the Parameter object. Default is adParamInput.
    </td>
  </tr>
  <tr>
    <td valign="top">
      size </td>
    <td valign="top">   Optional. Specifies the length of a variable-length data type, if such a type was declared in the
      <b> Type</b> parameter. Default is zero.</td>
  </tr>
  <tr>
    <td valign="top">
      value </td>
    <td valign="top"> Optional. The value of the Parameter object</td>
  </tr>
</table>
<br />
<hr />
<a name="datatypeenum"><h3>DataTypeEnum Values</h3></a>
<p>Specifies the data type of a Field, Parameter, or Property object</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top">
  <th width="30%">Constant</th>
  <th width="10%">Value</th>
  <th width="60%">Description</th>
</tr>
<tr>
  <td>adEmpty</td>
  <td>0</td>
  <td width="55%">No value</td>
</tr>
<tr>
  <td>adSmallInt</td>
  <td>2</td>
  <td width="55%">A 2-byte signed integer.</td>
</tr>
<tr>
  <td>adInteger</td>
  <td>3</td>
  <td width="55%">A 4-byte signed integer.</td>
</tr>
<tr>
  <td>adSingle</td>
  <td>4</td>
  <td width="55%">A single-precision floating-point value.</td>
</tr>
<tr>
  <td>adDouble</td>
  <td>5</td>
  <td width="55%">A double-precision floating-point value.</td>
</tr>
<tr>
  <td>adCurrency</td>
  <td>6</td>
  <td width="55%">A currency value</td>
</tr>
<tr>
  <td>adDate</td>
  <td>7</td>
  <td width="55%">The number of days since December 30, 1899 + the fraction of a
    day.</td>
</tr>
<tr>
  <td>adBSTR</td>
  <td>8</td>
  <td width="55%">A null-terminated character string.</td>
</tr>
<tr>
  <td>adIDispatch</td>
  <td>9</td>
  <td width="55%">A pointer to an <b>IDispatch</b>  interface on a COM object. <b class="le">Note:&nbsp;</b>Currently not supported by ADO.
  </td>
</tr>
<tr>
  <td>adError</td>
  <td>10</td>
  <td width="55%">A 32-bit error code</td>
</tr>
<tr>
  <td>adBoolean</td>
  <td>11</td>
  <td>A boolean value.</td>
</tr>
<tr>
  <td>adVariant</td>
  <td>12</td>
  <td width="55%">An Automation <b>Variant</b>. <b class="le">Note:</b><b class="le">
    </b>Currently not
    supported by ADO.
  </td>
</tr>
<tr>
  <td>adIUnknown</td>
  <td>13</td>
  <td width="55%">A pointer to an <b>IUnknown</b> interface on a COM
    object. <b class="le">Note: </b>Currently not
    supported by ADO.
  </td>
</tr>
<tr>
  <td>adDecimal</td>
  <td>14</td>
  <td width="55%">An exact numeric value with a fixed precision and
    scale.</td>
</tr>
<tr>
  <td>adTinyInt</td>
  <td>16</td>
  <td width="55%">A 1-byte signed integer.</td>
</tr>
<tr>
  <td>adUnsignedTinyInt</td>
12

⌨️ 快捷键说明

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