UC知道如何利用 SqlDataReader 把一张表显示出来?
来源：百度知道 编辑：UC知道 时间：2024/05/19 15:53:10
我用下面代码,怎么一片空白,一点反应也没有?
Dim drA As SqlDataReader = sqlcom.ExecuteReader()
Do While drA.Read()
Response.Write("User Id: " & drA.Item("UserId") & ", Password: ")
Response.Write(drA.Item(1) & "<br>")
Loop
Dim drA As SqlDataReader = sqlcom.ExecuteReader()
Do While drA.Read()
Response.Write("User Id: " & drA.Item("UserId") & ", Password: ")
Response.Write(drA.Item(1) & "<br>")
Loop
Dim drA As SqlDataReader = sqlcom.ExecuteReader()
if drA.hasrows
Do While drA.Read()
Response.Write("User Id: " & drA.Item("UserId") & ", Password: ")
Response.Write(drA.Item(1) & "<br>")
Loop
else
Response.write("没有行")
end if