ACCESS怎么连接？

来源：百度知道 编辑：UC知道 时间：2024/06/03 08:57:23
<configuration>
<appSettings>
<add key="MM_CONNECTION_HANDLER_sjk" value="e:\my\zc.mdb" />
<add key="MM_CONNECTION_STRING_sjk" value="" />
<add key="MM_CONNECTION_DATABASETYPE_sjk" value="OleDb" />
<add key="MM_CONNECTION_SCHEMA_sjk" value="" />
<add key="MM_CONNECTION_CATALOG_sjk" value="" />
</appSettings>
我的数据库连接不了，这里不知道怎么设置？

using System.Data.OleDb;

string strConnection="Provider=Microsoft.Jet.OleDb.4.0;Data Source='"+ConfigurationSettings.AppSettings["MM_CONNECTION_HANDLER_sjk"]+"'";

OleDbConnection objConnection=new OleDbConnection(strConnection);

objConnection.Open();
objConnection.Close();

//---------------Access数据库操作通用数据访问层---------
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Data.OleDb;
namespace Access
{
public class DataAccess
{
/// <summary>
/// OleDb数据库连接字符串
/// </summary>
private string connectString;

private OleDbCommand comm = new OleDbCommand();

private OleDbConnection conn = new OleDbConnection();

/// <summary>
/// 默认构造函数
/// </summary>
public DataAccess