1. 在Web.config文件中加入以下配置:
<
configuration
>
< appSettings >
< add key ="DataBasePath" value ="~/Database/Financial.mdb" />
< appSettings >
< add key ="DataBasePath" value ="~/Database/Financial.mdb" />
</
appSettings
>
</ configuration >
</ configuration >
2.新建一个Utility类,内容如下:
namespace
Web.Common
... {
/**//// <summary>
/// Utility 的摘要说明。
/// </summary>
public class Utility
...{
public Utility()
...{
//
// TODO: 在此处添加构造函数逻辑
//
}
/**//// <summary>
/// 得到一个OleDbConnection字符串
/// </summary>
/// <returns>OleDbConnection连接字符串</returns>
public string GetOleDbConnectionString()
...{
string prefixConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
string databasePath = System.Configuration.ConfigurationSettings.AppSettings["DataBasePath"];
prefixConnStr += System.Web.HttpContext.Current.Server.MapPath(databasePath);
return prefixConnStr;
}
/**//// <summary>
/// 得到一个OleDbConnection对象,返回值需要判断是否为null。
/// </summary>
/// <returns>OleDbConnection对象</returns>
public OleDbConnection GetOleDbConnection()
...{
try
...{
OleDbConnection conn = new OleDbConnection(GetOleDbConnectionString());
conn.Open();
return conn;
}
catch
...{
return null;
}
}
}
... {
/**//// <summary>
/// Utility 的摘要说明。
/// </summary>
public class Utility
...{
public Utility()
...{
//
// TODO: 在此处添加构造函数逻辑
//
}
/**//// <summary>
/// 得到一个OleDbConnection字符串
/// </summary>
/// <returns>OleDbConnection连接字符串</returns>
public string GetOleDbConnectionString()
...{
string prefixConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
string databasePath = System.Configuration.ConfigurationSettings.AppSettings["DataBasePath"];
prefixConnStr += System.Web.HttpContext.Current.Server.MapPath(databasePath);
return prefixConnStr;
}
/**//// <summary>
/// 得到一个OleDbConnection对象,返回值需要判断是否为null。
/// </summary>
/// <returns>OleDbConnection对象</returns>
public OleDbConnection GetOleDbConnection()
...{
try
...{
OleDbConnection conn = new OleDbConnection(GetOleDbConnectionString());
conn.Open();
return conn;
}
catch
...{
return null;
}
}
}
说明:本例假设Financial.mdb 数据库存在于项目的Database文件夹下,在创建了Utility类后,通过本类的GetOleDbConnection()即可得到OleDb的Collection对象。