ADO Type 属性
定义和用法
Type yana samu da cewa yana da kura ko kiyaye wanda zai iya kura ko kiyaye DataTypeEnum na cewa, wanda zai iya nuna rufin Parameter, Field ko Property na type.
| 对象 | na cewa Type |
|---|---|
| Parameter | gauna Parameter, Type yana samu da cewa yana da ikon aiki na daidai |
| Field | gauna Field na cikakawa Record na kungiyar Fields, Type yana samu ne kawai a cikin aikace-aikace na Value na Field ya kafa kaiwa, kuma data provider ya kaiwa cikin aikace-aikace na cewa ya kaiwa cikin aikace-aikace na Field tare da ciki da kuma cewa ya kaiwa cikin aikace-aikace na cewa ya kaiwa cikin aikace-aikace na Field. |
| Property | gauna Property, Type 属性 na ga na ga kafin |
语法
objectname.Type
实例
gauna Field
<%
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).Type)
rs.Close
conn.close
%>
gauna Parameter
<%
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
%>
gauna Property
<%
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 />")
response.write("Type:" & prop.Type & "<br />")
next
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
