ADO ma’lumotlarni ko‘rsatish
Recordset’dagi ma’lumotlarni ko‘rsatishning keng tarqalgan usuli — ularni HTML jadvalda ko‘rsatish.
Maydon nomlari va maydon qiymatlarini ko‘rsatish
Bizda "Northwind" nomli ma’lumotlar bazasi bor va biz "Customers" jadvalidagi ma’lumotlarni ko‘rsatmoqchimiz (faylni .asp kengaytmasi bilan saqlashni unutmang):
<html>
<body>
<%
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
do until rs.EOF
for each x in rs.Fields
Response.Write(x.name)
Response.Write(" = ")
Response.Write(x.value & "<br>")
next
Response.Write("<br>")
rs.MoveNext
loop
rs.close
conn.close
%>
</body>
</html>
Ma’lumotlarni HTML jadvalda ko‘rsatish
"Customers" jadvalidagi ma’lumotlarni quyidagi qatorlar yordamida HTML jadval ichida ham ko‘rsatishimiz mumkin (faylni .asp kengaytmasi bilan saqlashni unutmang):
<html>
<body>
<%
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 Companyname, Contactname FROM Customers", conn
%>
<table border="1" width="100%">
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
rs.close
conn.close
%>
</table>
</body>
</html>
HTML jadvalga sarlavhalar qo‘shish
HTML jadvalni o‘qishga qulayroq qilish uchun unga sarlavhalar qo‘shmoqchimiz (faylni .asp kengaytmasi bilan saqlashni unutmang):
<html>
<body>
<%
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")
sql="SELECT Companyname, Contactname FROM Customers"
rs.Open sql, conn
%>
<table border="1" width="100%">
<tr>
<%for each x in rs.Fields
response.write("<th>" & x.name & "</th>")
next%>
</tr>
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
rs.close
conn.close
%>
</table>
</body>
</html>
HTML jadvalga ranglar qo‘shish
HTML jadval chiroyli ko‘rinishi uchun unga ranglar qo‘shmoqchimiz (faylni .asp kengaytmasi bilan saqlashni unutmang):
<html>
<body>
<%
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")
sql="SELECT Companyname, Contactname FROM Customers"
rs.Open sql, conn
%>
<table border="1" style="width:100%;background-color:#fff5ee;">
<tr>
<%for each x in rs.Fields
response.write("<th style='text-align:left;background-color:#b0c4de;'>" & x.name & "</th>")
next%>
</tr>
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
rs.close
conn.close
%>
</table>
</body>
</html>
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!