求一段2.0中Access数据库连接字符串的使用代码

Question

不想用下面的绝对路径连接字符串:
<connectionStrings>
    <add name="WfcgDataConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\wwwroot\xxxxx\App_Data\xxxxxx.mdb"
      providerName="System.Data.OleDb" />
  </connectionStrings>想用相对路径的，如下：
<connectionStrings>
<add name="xxxxxxxx" connectionString="~/App_Data/xxxxxx.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>
请问在程序怎样使用？最好写成一个类

Answer 1

ConfigurationManager.ConnectionStrings["xxxxxxxx"].ConnectionString

Answer 2

using System.Data.OleDb;
public class DB
{ public static System.Data.OleDb.OleDbConnection createDB()
{
System.Web.HttpContext hc=System.Web.HttpContext.Current;
OleDbConnection con=new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source="+hc.Server.MapPath("/App_Data/xxxxxx.mdb")+";");
return con;

}

}

Answer 3

private void ReadRecords()
{
OleDbConnection conn = null;
OleDbDataReader reader = null;
try
{
conn = new OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; " + 
"Data Source=" + Server.MapPath("db/data.mdb"));
conn.Open();

OleDbCommand cmd = new OleDbCommand("Select * FROM admin", conn);
reader = cmd.ExecuteReader();
// DataGrid.DataSource = reader;
// DataGrid.DataBind();
}
finally
{
if (reader != null)  reader.Close();
if (conn != null)  conn.Close();
}
}