GetRows
ADO GetRows metodi
❮ Recordset obyektining to‘liq ma’lumotnomasi
GetRows metodi Recordset obyektidagi bir nechta yozuvni ikki o‘lchamli massivga nusxalaydi.
Sintaksis
vararray=objRecordset.GetRows(rows,start,fields)
| Parametr | Tavsif |
|---|---|
| rows | Ixtiyoriy. Olinadigan yozuvlar sonini belgilovchi GetRowsOptionEnum qiymati. Standart qiymati: adGetRowsRest. Eslatma: Agar bu argumentni tushirib qoldirsangiz, Recordset’dagi barcha yozuvlar olinadi |
| start |
Ixtiyoriy. Qaysi yozuvdan boshlash: yozuv raqami yoki BookmarkEnum qiymati |
| fields | Ixtiyoriy. Agar GetRows chaqiruvi qaytaradigan maydonlarnigina ko‘rsatmoqchi bo‘lsangiz, bu argumentda bitta maydon nomi/raqamini yoki maydon nomlari/raqamlari massivini uzatish mumkin |
Misol
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn
'The first number indicates how many records to copy
'The second number indicates what recordnumber to start on
p=rs.GetRows(2,0)
rs.close
conn.close
'This example returns the value of the first
'column in the first two records
response.write(p(0,0))
response.write("<br>")
response.write(p(0,1))
'This example returns the value of the first
'three columns in the first record
response.write(p(0,0))
response.write("<br>")
response.write(p(1,0))
response.write("<br>")
response.write(p(2,0))
%>
GetRowsOptionEnum qiymatlari
| Konstanta | Qiymat | Tavsif |
|---|---|---|
| adGetRowsRest | -1 | Recordset obyektidagi qolgan yozuvlarni oladi |
BookmarkEnum qiymatlari
| Konstanta | Qiymat | Tavsif |
|---|---|---|
| adBookmarkCurrent | 0 | Joriy yozuvdan boshlaydi |
| adBookmarkFirst | 1 | Birinchi yozuvdan boshlaydi |
| adBookmarkLast | 2 | Oxirgi yozuvdan boshlaydi |
❮ Recordset obyektining to‘liq ma’lumotnomasi
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!