□一、ASP.Net与Access数据库连...... 一、ASP.Net与Access数据库连接: <%@ Import Namespace="system.data.oledb" %> <%@ Import Namespace="system.data" %> <%@ Import Namespace="System.IO" %> <% Dim dbconn as OledbConnection dbconn = new OledbConnection("provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("XXX.mdb")) %> 二、ASP.Net与SQL数据库连接: <%@ Import Namespace="system.data.oledb" %> <%@ Import Namespace="system.data" %> <%@ Import Namespace="System.IO" %> <% Dim dbconn as OledbConnection dbconn = new OledbConnection("provider=sqloledb;server=主机名称;initial catalog=数据库名称;user id=XXX;password=XXX;") %> 建立记录集对象: <% Dim i as integer Dim sql as OledbDataAdapter Dim ds as new dataset sql = new OledbDataAdapter("select * from contact",dbconn) sql.fill (ds,"guest") %> |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-30 03:30 , Processed in 0.091362 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.