62,046
社区成员
发帖
与我相关
我的任务
分享
//首先,web.config文件中加入如下项目
//<appSettings>
// <add key="OLEDBCONNECTIONSTRING" value="provider=microsoft.jet.oledb.4.0;data source="/>
// <add key="dbPath" value="~/App_Data/Data.mdb"/>
//</appSettings>
//一:创建类库项目时,默认是没有添加System.Web的,在项目名称上右键,找到System.Web加上就可以了(适用于多层程序)
//二:在APP_Code文件夹下,建立一个class文件,如下代码
public class DB
{
public static OleDbConnection CreateConn()
{
return new OleDbConnection(ConfigurationManager.AppSettings["OLEDBCONNECTIONSTRING"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]));
}
}
//程序中需要调用数据库连接的地方,如下实例化一个oledbconnection对象OleDbConnection myconn = DB.CreateConn();
//然后下面就可以调用SQlHelper了,像这样
DataSet ds = SqlHelper.ExecuteDataset(myconn, CommandType.Text, "select * from categories");
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source="/>
<add key="ConnectionString2" value="App_Data\test.mdb"/>
/// <summary>
/// 获取连接字符串
/// </summary>
public static string ConnectionString
{
get
{
string _connectionString = ConfigurationManager.AppSettings["ConnectionString"] + System.Web.HttpContext.Current.Server.MapPath("~" + "/" + ConfigurationManager.AppSettings["ConnectionString2"]);
string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
if (ConStringEncrypt == "true")
{
_connectionString = DESEncrypt.Decrypt(_connectionString);
}
return _connectionString;
}
}