怎样连接Access,请大侠给个具体例子！谢！！！

[ligenyu2005]

怎样连接Access,请大侠给个具体例子！谢！！！

[ligenyu2005]

怎样连接Access,请大侠给个具体例子！谢！！！

[孟子E章]

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", ""

[孟子E章]

string cnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
cnString += System.Web.HttpContext.Current.Server.MapPath("TestTable.mdb")
OleDbConnection cn = new OleDbConnection(cnString);
cn.Open();
cnString = "SELECT TOP 15 D.Title,D.CreateDate,S.Title AS SubTitle ";
cnString += "FROM Document D,Subject S WHERE D.pid=S.id ORDER BY D.CreateDate DESC";
OleDbCommand cmd = new OleDbCommand(cnString,cn);
xpTable.DataSource=cmd.ExecuteReader(CommandBehavior.CloseConnection);
xpTable.DataBind();
cmd.Dispose();
cn.Close();
cn.Dispose();
cn = null;

[李洪喜]

这种贴子还让老孟回贴！

[elangsos]

我来个比较清晰好懂的。

//code list in winform
string connect="Provider=Microsoft.JET.OLEDB.4.0;"+@"data source=d:\test.mdb";
OleDbConnection dbcon=new OleDbConnection(connect);
OleDbDataAdapter adapter=new OleDbDataAdapter();
string command ="select [id],[name],[mood],[content],[settime] from book";
adapter.SelectCommand=new OleDbCommand(command,dbcon);
//DataSet
DataSet ds=new DataSet();
try
{
adapter.Fill(ds,"book");
}
catch(Exception e)
{
MessageBox.Show(e.Message,"warning");
}
dataGrid1.DataSource=ds;
dataGrid1.DataMember="book";
dbcon.Close();