正在加载图片...
令中国铁道出版社 9.2数据库查询泡 为了改善上述的缺点,我们将ASP程序代码(c9-1asp列出来, 以供读者参考: <9 dim Conn rs Set Conn= Server Create Object("ADODB Connection Conn Open"Driver=SQL Server); Database=northwind Server- Local); uid=sa, pwd Set rs= Server CreateObject("ADODB. Recordset") sql ="select from Customers order by CustomerID rsopen sql, conn, 3, 2 <html> <body> center> <font face="Arial "size=5>SQL Server<br> Northwind Database Listing demo</font> <table border=0 cellpadding=0 cellspacing-I width=100%> <tr bgcolortccccd7> (77 9.2 数据库查询范例 为了改善上述的缺点，我们将ASP程序代码(ch9-1.asp)列出来， 以供读者参考： <% dim Conn, rs Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Driver={SQL Server};Database=northwind; Server=(Local); uid=sa;pwd=" Set rs = Server.CreateObject("ADODB.Recordset") sql = "Select * from Customers order by CustomerID" rs.open sql, conn, 3, 2 %> <html> <body> <center> <p> <font face="Arial" size=5>SQL Server<br> Northwind Database Listing Demo</font> </p> <table border=0 cellpadding=0 cellspacing=1 width=100%> <tr bgcolor=#ccccd7>