HOME HTML CSS XML JAVASCRIPT ASP PHP SQL MORE...

ADO Tutorial

ADO HOME
ADO Intro
ADO Connect
ADO Recordset
ADO Display
ADO Query
ADO Sort
ADO Add
ADO Update
ADO Delete
ADO Demo
ADO Speed Up

ADO Objects

ADO Command
ADO Connection
ADO Error
ADO Field
ADO Parameter
ADO Property
ADO Record
ADO Recordset
ADO Stream
ADO DataTypes

ADO Summary

ADO Examples

ADO Exam

ADO Certificate

ADO Name Property

Complete Parameter Object Reference

The Name property sets or returns a string that contains the name of a Command, Property, Field, or Parameter object.

Object	Description of the Name Property
Command	The Name property has read/write permissions on a Connection object
Property	The Name property has read-only permissions on a Property object
Field	The Name property has read/write permissions when used to create a Recordset, but it has read-only permissions when you open an existing Recordset
Parameter	The Name property has read/write permissions on a Parameter object that is not added to the Parameters Collection, but it has read-only permissions after the object is added to the Collection

Syntax

object.Name

Example - For a Command object

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

set comm=Server.CreateObject("ADODB.Command")
comm.Name="xx"
response.write(comm.Name)

conn.close
%>

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

set f=Server.CreateObject("ADODB.Field")

'Display the field attributes of the Orders Table
for each f in rs.Fields
 response.write("Attr:" & f.Attributes & " ")
 response.write("Name:" & f.Name & " ")
 response.write("Value:" & f.Value & " ")
next

rs.Close
conn.close
set rs=nothing
set conn=nothing
%>

Example - 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 & " ")
 response.write("Name:" & prop.Name & " ")
 response.write("Value:" & prop.Value & " ")
next

rs.close
conn.close
set rs=nothing
set conn=nothing
%>