添加引用 adodb component然后:ADODB.ConnectionClass conn = new ADODB.ConnectionClass();
string strConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\data.mdb;";
conn.Open(strConn, "", "", 0);string strSQL = "SELECT * FROM Table1";
ADODB.RecordsetClass rst = new ADODB.RecordsetClass();
rst.Open(strSQL, conn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly, 0);
.....
string strConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\data.mdb;";
conn.Open(strConn, "", "", 0);string strSQL = "SELECT * FROM Table1";
ADODB.RecordsetClass rst = new ADODB.RecordsetClass();
rst.Open(strSQL, conn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly, 0);
.....
string strConn = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;User Id=sa;Password=;"
//User id 是你SQL Server用户
//Password 是这个用户的密码
string strSQL = "SELECT * FROM Table1";
ADODB.RecordsetClass rst = new ADODB.RecordsetClass();
rst.Open(strSQL, conn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly, 0);
.....