The State property returns a value that describes if the object is open, closed, connecting, executing or retrieving data. The value returns an ObjectStateEnum value. Default is adStateClosed.
State属性的作用是：返回一个用于描述指令对象是否已被打开、关闭、或正在连接、执行以及获取数据的值。这个值将返回一个ObjectStateEnum值。默认值是：adStateClosed。

This property can be used with the Command, Connection, Record, Recordset, and Stream object.
该属性可以通过Command、Connection、Record、Recordset和 Stream对象。

The State property can have a combination of values. If a statement is executing, this property will have a combined value of adStateOpen and adStateExecuting.
这个陈述语句可以拥有一个符合值。如果某条语句正在执行中，那么，这个属性将拥有一个adStateOpena和dStateExecuting的复合值。

Syntax
语法

object.State

Example
案例

<%
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")
response.write(comm.State)

conn.close
%>

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

response.write(conn.State)

conn.close
%>

ObjectStateEnum Values
ObjectStateEnum值

Specifies whether an object is open or closed, connecting to a data source, executing a command, or retrieving data.
制定一个对象是否已被打开或关闭，以及是否正在连接数据源，执行一个指令或者获取数据。

评论 (0) All