sql读取的小问题,配合ASP的

来源:百度知道 编辑:UC知道 时间:2024/06/15 01:05:14
我初学SQL,现在想知道怎么从数据库读取个内容然后显示在ASP的网页上啊~比如从里面读取一篇文章显示出来啊,随便怎么显示出来,一定要从数据库中读取,我会连接的~

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
set rs_Product=server.createobject("adodb.recordset")
sqltext="select top " & Product_count & " * from Product where Passed="&TrueType&" And FirstPage="&TrueType&" order by UpdateTime desc"
rs_Product.open sqltext,conn,1,1
%>
<tr align="center">
<%
If rs_Product.eof and rs_Product.bof then
response.write "<td><p align='center'><font color='#ff0000'>还没任何产品</font></p></td>"
else
row_count=1
Do While Not rs_Product.EOF%>
<td><table border="0" cellpadding="0" cellspacing="8" >
<tr>
<td width="38%" height="30"><table width="100%" border="0" cellspacing=&qu