应用程序的ACCESS连接

[chinaxifan]

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

[toxxj]

<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);

[chinaxifan]

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

实在是不懂啊.