ADO Value Property


The Value property sets or returns the value of a Parameter, Field, or Property object.

Object Description of the Value Property
Parameter The Value property sets or returns a variant that indicates the value of the Parameter object 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
Field The Value property sets or returns a variant that indicates the current value of the Field object
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
Property The Value property sets or returns a variant that indicates the current value of the Property object 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
%>

Goto ADO Property Object Complete List
Share this article :
 
Copyright © 2012. Best Online Tutorials | Source codes | Programming Languages - All Rights Reserved