ADO Recordset
Ma’lumotlar bazasidagi ma’lumotlarni o‘qish uchun avval ularni Recordset’ga yuklash kerak.
ADO jadval Recordset’ini yaratish
Oldingi bobda ko‘rsatilganidek, ADO ma’lumotlar bazasi ulanishi yaratilgandan so‘ng ADO Recordset yaratish mumkin.
Faraz qilaylik, bizda "Northwind" nomli ma’lumotlar bazasi bor; undagi "Customers" jadvaliga quyidagi qatorlar yordamida murojaat qilishimiz mumkin:
<%
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
%>
ADO SQL Recordset’ini yaratish
"Customers" jadvalidagi ma’lumotlarga SQL yordamida ham murojaat qilishimiz mumkin:
<%
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
%>
Recordset’dan ma’lumotlarni ajratib olish
Recordset ochilgandan so‘ng undan ma’lumotlarni ajratib olishimiz mumkin.
Faraz qilaylik, bizda "Northwind" nomli ma’lumotlar bazasi bor; undagi "Customers" jadvaliga quyidagi qatorlar yordamida murojaat qilishimiz mumkin:
<%
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 Recordset obyekti
ADO Recordset obyekti ma’lumotlar bazasi jadvalidan olingan yozuvlar to‘plamini saqlash uchun ishlatiladi.
Recordset obyektining barcha metod va xususiyatlarini ko‘ring.
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!