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

Question

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

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

Answer 2

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;

Answer 3

我来个比较清晰好懂的。//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();