Question

如何在.asp中实现网页对SQL中表的查询功能并显示在网页中,求过程

图书管理系统，连接的数据库是SQL2000，在DW CS5中写代码实现查询功能

Answer 1

Set Rs = server.CreateObject("ADODB.Recordset")
Rs.open "SELECT * FROM [表名] ORDER BY [排序的字段名] ASC", conn, 1, 1 'Desc倒序；Asc正序

If Not Rs.EOF Then
For i = 1 To Rs.RecordCount
Response.Write Rs("字段名") ‘输出字段的内容
Rs.MoveNext
Next
Rs.Close
Set Rs=Nothing

Answer 2

Set Rs = server.CreateObject("ADODB.Recordset")Rs.open "SELECT * FROM [表名] ORDER BY [排序的字段名] ASC", conn, 1, 1 'Desc倒序；Asc正序
if rs.recordcount<>0 then
response.write(rs("[字段名]")&"<br>")
rs.movenext
loop

Answer 3

response.write方法

Answer 4

Rs.open "SELECT * FROM [表名] ORDER BY [排序的字段名] ASC", conn, 1, 1 'Desc倒序；Asc正序