Mifano ya ADO Name

Mifano na Matumizi

kina jina kinasababu ya kusoma au kusoma kwa sababu ya kusoma kina jina kinahusiana kwa Command, Property, Field au Parameter.

object kina jina kinahusiana kwa sababu ya kusoma kwa kina jina.
Command kina jina kinahusiana kwa sababu ya kusoma/kusoma kwa Command.
Property kina jina kinahusiana kwa sababu ya kusoma kwa Property.
Field kwa kina jina kina kiwango cha kusoma/kusoma kwenye kina jina kwenye Recordset kina kiwango cha kusoma, tena kina jina kina kiwango cha kusoma kwenye Recordset kina kiwango cha kusoma.
Parameter kwa Parameter kipya kwenye kundi ya Parameters, kina jina kinahusiana kwa sababu ya kusoma na kusoma/kusoma. Kwa kila object kipya na kila kina jina kinahusiana, kina jina kinahusiana kinasababu ya kusoma. Jina kinasababu ya kusoma hauwezi kuwa pekee kwenye kundi.

mawazo

object.Name

mivuno

kwa kwanza Command kwanza:

<%
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
%>

kwa kwanza Field kwanza:

<%
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")
'Onyesha vipso vya mifano ya Tabeli ya Orders
for each f in rs.Fields
  response.write("Attr:" & f.Attributes & "<br />")
  response.write("Name:" & f.Name & "<br />")
  response.write("Value:" & f.Value & "<br />")
next
rs.Close
conn.close
set rs=nothing
set conn=nothing
%>

kwa Property kwanza:

<%
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")
'Onyesha viwango vya hatua ya Tablica ya Orders
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
%>