koyarwa bincaye:
ADO Value attiyar
tasiri da koyarwa
| Value attiyar za a iya dasa ko a iya samar da wuri na yau wuri Parameter, Field ko Property object. | wuri |
|---|---|
| ba'a attiyar Value |
Parameter Value wuri za a iya dasa ko a iya samar da wuri variant, wanda ke nufin wuri na yau wa'ada Parameter object. |
| bincaye: Kafin a bincika attiyar Value, an bashi kammala wa'ada Recordset object. Don wa'ada Parameter object, ADO ne ke bincika attiyar Value na kai tsaye. |
Field bincaye: Wa'ada Value za a iya dasa ko a iya samar da wuri variant, wanda ke nufin wuri na yau wa'ada Field object. Duk da haka, wa'ada Value za a iya dasa ko a iya samar da wuri na yau wa'ada Property object. |
| Property |
Value attiyar za a iya dasa ko a iya samar da wuri variant, wanda ke nufin wuri na yau wuri Property object. bincaye: Ba'a ba'a yana yiin kara da matsakaiciyar Value wa'ada. |
furo
objectname.Value
shakhsi
kafin 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
%>
kafin 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
%>
kafin 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
%>
