.net中access数据库的连接字符串怎么写？

[windyuanzhihong]

网站之前做好了，是用的SQL 2005做数据库的，现在数据库换成access，我已经将sql 2005数据表导入到access中，请问
web.config文件里的连接字符串应该怎么写，请说详细些，我对字符串连接不是很熟悉，我之前的连接字符串为：
<!--<add name="MyConnectionString" connectionString="Data Source=.\sqlexpress;AttachDbFilename='D:\My Documents\luantai\data\luntai.mdf';Integrated Security=True" providerName="System.Data.SqlClient"/>-->
现在转的access数据库为：luntai.accdb,请知道的告诉我，在线等，很急，谢谢...

[ck11926375]

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

[igelf]

private static string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("/GuangDong/App_Data/#HS.mdb");

[Lovely_baby]

web.config的配置

<appSettings>
  <add key="provider" value="Provider=Microsoft.Jet.OLEDB.4.0;data source="/> 
  <add key="dbPath" value="~/db\data.mdb"/> //注意必须加~/,代表根目录
</appSettings>
 

[flyerwing]

[Quote=引用 2 楼 igelf 的回复:]
C# codeprivatestaticstring connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ HttpContext.Current.Server.MapPath("/GuangDong/App_Data/#HS.mdb");
[/Quote]
好象使这个。

[十八道胡同]

和连接sql2005差不多,只需要该连接字符串即可.

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

namespace TestAccess
{
    class Program
    {
        static void Main(string[] args)
        {
            #region Access 2007
            Console.WriteLine("Access 2007");
            string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
            strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\Database1.accdb;";
            strConnection += "Persist Security Info=False";
            using (OleDbConnection objConnection = new OleDbConnection(strConnection))
            {
                objConnection.Open();
                OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from Couse", objConnection);
                DataSet ds = new DataSet();
                myCommandd.Fill(ds, "couse");
                DataTable dt = ds.Tables["couse"];
                Console.WriteLine(dt.Columns[0].ToString());
                Console.WriteLine(dt.Columns[1].ToString());
                Console.WriteLine(dt.Columns[2].ToString());

                objConnection.Close();

            }
            #endregion
}
}
}

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/LCL_data/archive/2009/05/06/4154255.aspx

[cfesc9]

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|数据库名称.mdb"用这种方法，只要把数据库文件放到App_Data里边就可以了。
我用过，没问题……

[段传涛]

webconfig
office是03
<add key ="Excon" value ="Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0; Data Source="/>
office是07
add key ="Excon" value =“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False”;

[windyuanzhihong]

[Quote=引用 7 楼 jason_dct 的回复:]
webconfig
office是03
<add key ="Excon" value ="Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0; Data Source="/>
office是07
add key ="Excon" value =“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False”;

[/Quote]
add key是web.config里面的哪个节点里加，appSettings还是connectionStrings？
若连接成功了，我以前操作数据库用的那些sqlConnection,sqlDataAdapter类都要换？

[capucivar]

web.config中：
<appSettings>
<add key="access" value="provider=Microsoft.Jet.oledb.4.0;data source=."/>
<add key="accesspath" value="~/mydb.mdb"/>
</appSettings>

连接数据库时取得web.cnfig中的连接字符串：
string dbconn = ConfigurationManager.AppSettings["access"].ToString() + HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["accesspath"].ToString());

[wuyq11]

connectionstring.com
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/>

<appSettings>
<add key="ConnString" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~/App_Data/a.mdb"/>
</appSettings>