Recommended: A brief analysis of the asp program to create an access database The access database belongs to a "file database". When creating, you need to specify the file it wants to use, as shown below: SetCatalog_object=Server.CreateObject(ADOX.Catalog) Catalog_object.Create(Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Server.MapPath(/Database.mdb)) Two simple sentences
<%sql=select*fromserrwhereorderbyidasc
setrs=server.createobject(adodb.recordset)
rs.opensql,conn,1,1
%><styletype=text/css>
<!--
body,td,th{
font-size:12px;
}
-->
</style>
<tablewidth=100%align= 'center'>
<%
fori=1tors.recordCount 'Variable i loops from 1 to the number of records in the data
if(imod4=1)then 'Each tr displays 4 records, can be modified by yourself as needed
response.write<tr>
endif
response.write<tdwidth=200>&rs(title)&<br>&rs(con)&<br>&rs(www)&<br>&rs(keyword)&</td>
if(imod4=0)then
response.write</tr>
endif
rs.movenext
next
rs.close
%>
</table>
Share: Revealing the tips of using single quotes and double quotes and connectors in ASP 1. Single quotes: Just like learning Chinese class, the quotes that continue to be placed in double quotes can be single quote response.write(Iamhere) 2. The double quotes in ASP can be any characters or strings. HTML code 1.%response.write(Iamhere)%%response.write(cnbrucehere)%2.%response.write(bIamhe