应用程序的ACCESS连接

Question

我做了一个类
在WEB里写
Database = System.Windows.Forms("App_Data/ktvdb.mdb"); Connstr = "Provider=" + Provider + "DataSource=" + Database;
然后我复制到应用程序里不行,应该怎么做?

Answer 1

 <appSettings>
    <add   key="provider"   value="microsoft.jet.oledb.4.0"   />
    <add   key="datasource"   value="~/App_Data/data.mdb"   />
    
  </appSettings>==================
string s = String.Format("Provider={0};Data source={1}", System.Configuration.ConfigurationSettings.AppSettings["provider"], Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["datasource"]));
            
            string strinsert = "insert into atable(t_qh,t_name,t_gh,t_date,t_time,t_bah,t_ftime,t_kf,t_bj) values (@t_qh,@t_name,@t_gh,@t_date,@t_time,@t_bah,@t_ftime,@t_kf,@t_bj)";
            System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection(s);
            System.Data.OleDb.OleDbCommand cmdinsert = new System.Data.OleDb.OleDbCommand(strinsert, cn);

Answer 2

Server.MapPath好象在应用程序里会出错.string Provider, Database, Connstr;
Provider = "Microsoft.Jet.OLEDB.4.0;";
Database = System.Windows.Forms.Application.StartupPath + "App_Data/db.mdb"; 
Connstr = "Provider=" + Provider + "Data Source=" + Database; 为什么路径不是\bin\DebugApp_Data\App_Data
而是\bin\DebugApp_Data\ktvdb.mdb实在是不懂啊.