ADO Name Jicho

Kutumia Mshakilishi wa Field cha ADO

Mifano na Matumizi

Jicho ya Name inaweza kubadilishwa au kuelewa kuwa namba inayotengenezwa na jicho cha Command, Property, Field au Parameter.

Kipengele Inasomo ya jicho ya Name
Command Jicho ya Name ina uadilifu kuelewa/kusoma kwa kipengele cha Command.
Property Jicho ya Name ina uadilifu kuelewa kwa Property ya jicho.
Field Kwa jicho ya Name kwenye kipengele kusaidia kwa Recordset ina uadilifu kuelewa/kusoma, lakini kama inapotea Recordset yetu ina jicho tu.
Parameter Kwa Parameter kipengele yetu kusaidia kwa Parameters kipengele, Name ya jicho ni kuelewa/kusoma. Kwa kipengele yetu yanaongezwa na kipengele yote kina jicho tu. Jina kwenye kipengele haingepo uadilifu.

Inasomo

object.Name

mimbo

kwa kipengele cha Command:

<%
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 kipengele cha 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
set f=Server.CreateObject("ADODB.Field")
'Kuonyesha uwezo wa kipendekezo cha Table 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 kipengele:

<%
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")
Muonekano wa jicho la matumizi 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
%>

Kutumia Mshakilishi wa Field cha ADO