请问如何连接ACCESS数据库？急！在线等！

RacoXu 2004-09-13 10:40:44

请问如何在ASP.NET连接ACCESS数据库呢？C#的语法。谢谢，非常急！
解决马上揭帖。

...全文

222 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

aliketen 2004-12-13

打赏
举报

mark

RacoXu 2004-09-13

打赏
举报

ok搞定了，谢谢各位

pingnt 2004-09-13

打赏
举报

C#代码:
string strCon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=asdasd;" ;

sqlConnection objCon=new sqlConnection(strCon);

ny_nicholas 2004-09-13

打赏
举报

sfchina 2004-09-13

打赏
举报

其实完全不需要记忆的
在form中放置一个OleDbConnection 控件,然后用它的属性里的ConnectingString向导就可以获得想要的数据库连接字符串！！呵呵~~

wuhun 2004-09-13

打赏
举报

Access
ODBC

Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"

Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin", ""

OLEDB, OleDbConnection (.NET)

Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=asdasd;"

Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;","admin", ""

With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;","admin", ""

ny_nicholas 2004-09-13

打赏
举报

其中dgSchema是dataGrid

ny_nicholas 2004-09-13

打赏
举报

dim strConnection as string="provider=Microsoft.Jet.OLEDB.4.0;" & _
"datasource=c:\nwind.mdb"
dim objconection as new oledbConnection(strConnection)

dim dsSchema as DataSet = New DataSet()
dim dtSchema as DataTable

objConnection.Open()
dtSchema=objConnection.GetOleDbSchemaTable( _
OleDbSchemaGuid.Tables,Nothing)

dsSchema.Tables.add(dtSchema)
dgSchema.DataSource=dsSchema
dgSchema.DataBind()
objConnection.Close()

zjhphc 2004-09-13

打赏
举报

1) ODBC

Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"

Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin", ""

2) OLEDB, OleDbConnection (.NET)

Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=asdasd;"

Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;","admin", ""

With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;","admin", ""