当前位置: 首页 > 网络学院 > 服务端脚本教程 > ADO > ADO Value 属性

ADO
ADO介绍
ADO数据库连接
ADO记录集
ADO显示记录
ADO查询语句
ADO记录排序
ADO添加记录
ADO更新记录
ADO删除记录
ADO演示
ADO提升执行速度
ADO Command对象
ADO Connection对象
ADO Error
ADO Field
ADO Parameter
ADO 属性
ADO Record
ADO Recordset
ADO Stream

ADO Value 属性


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-03-04   浏览: 426 ::
收藏到网摘: n/a

The Value property sets or returns the value of a Parameter, Field, or Property object.
Value属性的作用是:设置或返回一个参数、字段或属性对象的值。

Object
对象
Description of the Value Property
Value属性描述
Parameter The Value property sets or returns a variant that indicates the value of the Parameter object
Value属性设置或返回了一个用来指示Parameter[参数]对象的值

Note: The Recordset should be closed before you try to read the Value property. ADO can only read the Value property once from the provider
注意:记录集必须在你尝试读取Value属性之前关闭。ADO仅可以从技术提供对象[provider]处读取Value值一次

Field

The Value property sets or returns a variant that indicates the current value of the Field object
Value属性设置或返回了一个用来指示当前Field[字段]对象的值

Note: For a new Field object that are added to the Fields collection of a Record, you must first set the Value property and perform an update before you can set any other property
注意:对于一个新添加到一个记录中字段集内的字段对象而言,你必须首先对Value属性进行设置,并在你设置其它属性之前对Value属性进行更新

Property The Value property sets or returns a variant that indicates the current value of the Property object
Value属性设置或返回了一个用来指示当前Property[属性]对象的值

Note: You cannot set the Value for properties that are read-only
注意:你不能对一个只读属性设置一个值

Syntax
语法

objectname.Value

Example
案例

For a Field object:

<%
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 orders", conn
response.write(rs.Fields(0).Value)
rs.Close
conn.close
%>

For a Parameter object:

<%
set comm=Server.CreateObject("ADODB.Command")
set para=Server.CreateObject("ADODB.Parameter")
para.Type=adVarChar
para.Size=25
para.Direction=adParamInput
para.Value=varfname
comm.Parameters.Append para
%>

For a Property object:

<%
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 orders", conn
set prop=Server.CreateObject("ADODB.Property")
'Display the property attributes of the Orders Table
for each prop in rs.Properties response.write("Attr:" & prop.Attributes & "<br />") response.write("Name:" & prop.Name & "<br />") response.write("Value:" & prop.Value & "<br />")
next
rs.close
conn.close
set rs=nothing
set conn=nothing
%>

评论 (0) All

登陆 | 还没注册?