ADO Recordset (Kwanan Kwanan)

Baya a zai iya ganin data daga database, data a kaiyawa zai iya kai wa tabbin ɗan gani.

An fara farawa wani ADO table recordset (ADO Table Recordset)

Bayan an fara farawa wani ADO database connection, kamar yadda an kira a ita babba, koyaushe a zai iya fara gina wani ADO recordset.

Assume wajin a kofin 'Northwind' na baɗa, a zai iya ganin tabbin 'Customers' na baɗa ta kowacce:

<%
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 "Customers", conn
%>

An fara farawa wani ADO SQL tabbin ɗan gani (ADO SQL Recordset)

A zai iya gani data daga tabbin 'Customers' na baɗa ta SQL:

<%
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 Customers", conn
%>

Yin data daga tabbin ɗan gani

Baya tabbin baɗa ya yi ɗan gani, a zai iya yin data daga tabbin ɗan gani.

Assume wajin a kofin 'Northwind' na baɗa, a zai iya ganin tabbin 'Customers' na baɗa ta kowacce:

<%
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 Customers", conn
for each x in rs.fields
   response.write(x.name)
   response.write(" = ")
   response.write(x.value)
next
%>

ADO 记录集对象（ADO Recordset Object）

ADO Recordset 对象可被用来容纳来自数据库表的记录集。

查看 ADO Recordset 对象的所有方法和属性。