UC知道VS2003c#连接ACCESS
来源：百度知道 编辑：UC知道 时间：2024/06/20 09:21:06
public Conn()
{
_conn = new SqlConnection("Server=.; DataBase=Total; Integrated Security=true");
}
public DataTable SearchTable(String sql, String tableName)
{
try
{
DataTable table = new DataTable(tableName);
_adapter = new SqlDataAdapter(sql, _conn);
_adapter.Fill(table);
return table;
}
catch (Exception ex)
{
throw ex;
}
}
sql是OK的，但现在想转用ACCESS，要如何修改才能读取MDB呢？
{
_conn = new SqlConnection("Server=.; DataBase=Total; Integrated Security=true");
}
public DataTable SearchTable(String sql, String tableName)
{
try
{
DataTable table = new DataTable(tableName);
_adapter = new SqlDataAdapter(sql, _conn);
_adapter.Fill(table);
return table;
}
catch (Exception ex)
{
throw ex;
}
}
sql是OK的，但现在想转用ACCESS，要如何修改才能读取MDB呢？
Access
ODBC
Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;"
Exclusive:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="
把这句改了
_conn = new SqlConnection("Server=.; DataBase=Total; Integrated Security=true");