Posted on 2006-11-05 00:35
苑 閱讀(148)
評(píng)論(0) 編輯 收藏 所屬分類:
ASP/ASP.NET
<%
'以O(shè)LEDB形勢(shì)訪問SQL Server數(shù)據(jù)庫
?set con=server.CreateObject("adodb.connection")
?con.connectionstring="provider=sqloledb;data source=.;uid=sa;pwd=;database=server"
?con.open
?set rs=server.CreateObject("adodb.recordset")
?sql="select * from kop"
?rs.open sql,con,2,3
?response.Write(rs("id")&" ")
?response.Write(rs("name")&" ")
?response.Write(rs("http")&" ")
?response.Write(rs("adds")&" ")
%>
<%
'以O(shè)LEDB形勢(shì)訪問Access數(shù)據(jù)庫
?set con=server.CreateObject("adodb.connection")
?con.connectionstring="provider=microsoft.jet.oledb.4.0;data source="&MapPath("color.mdb")
?con.open
?set rs=server.CreateObject("adodb.recordset")
?sql="select * from class1"
?rs.open sql,con,2,3
?response.Write(rs("id")&" ")
?response.Write(rs("name")&" ")
?response.Write(rs("http")&" ")
?response.Write(rs("fileworks")&" ")
%>