Question

怎么将SQL查询分析器的查询结果显示在ASP中的某一控件中？

SELECT Train_Num,COUNT(*)
FROM OrderInformation
WHERE Order_Num BETWEEN 20110701000001 AND 20110701001000
GROUP BY Train_Num
ORDER BY COUNT(*) DESC;

Answer 1

<%
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.Mappath("数据库.mdb")
set conn=Server.CreateObject("ADODB.Connection")
conn.Open connstr

set rs=conn.execute("select Train_Num,COUNT(*) from OrderInformation where Order_Num between 20110701000001 and 20110701001000 group by Train_Num order by COUNT(*) desc")

response.write(rs("要输出显示的字段"))

%>

Answer 2

绑定 即可啊 ..至于你要用啥控件我就不知道了。
绑定有2种方式，直接在页面操作,.cs文件里面手写绑定！

追问

在页面怎么操作啊？具体的！谢谢

追答

能告诉我用什么控件吗?很简单的啊..

追问

linkbutton