连接access数据库:
string strConn = "Provider=Microsoft.Jet.OleDb.4.0;DataSource = " &Server.MapPath("your.mdb");
string strConn = "Provider=Microsoft.Jet.OleDb.4.0;DataSource = " &Server.MapPath("your.mdb");
调试欢乐多
Dim cnA As OledbConnection
cnA=New ADOConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Inetpub\wwwroot\yicman\data\shuju.mdb"
)
dim cma as adocommand=new Oledbcommand("Insert Into xiangtankr Values('aa','bb','cc','dd'), cnA
)
cnA.Open()
cmA.ExecuteNonQuery()
end sub
Dim cnA As OledbConnection
cnA=New OledbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Inetpub\wwwroot\yicman\data\shuju.mdb"
)
dim cma as adocommand=new Oledbcommand("Insert Into xiangtankr Values('aa','bb','cc','dd'), cnA
)
cnA.Open()
cmA.ExecuteNonQuery()
end sub
http://dev.csdn.net/develop/article/16/16437.shtm
dim cnn as new oledbconnection(strconn)
dim cmd as new oledbcommand("select * from tablename",cnn)
都 可以。注意server.mappath虚拟路径的设置。