How to connect asp.net to the database is C #

刃之魂

<add key = "ConnectionString" value = "Provider = Microsoft.Jet.OleDb.4.0; Data Source = MapPath (Northwind.mdb)" />

I want a relative path?
How about it?

Help out

klongvv

<add key = "ConnectionString" value = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =. / Northwind.mdb" />
./ represents the current path.

liyaoxing

<appSettings>
       <add key = "con" value = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source ="> </ add>
       <add key = "data" value = "/ Data / mdb"> </ add>
</ appSettings>

string myCon = System.Configuration.ConfigurationSettings.AppSettings ["con"] + HttpContext.Current.Server.MapPath ("~" + System.Configuration.ConfigurationSettings.AppSettings ["data"]);

lisongfox

OleDbConnection con = new OleDbConnection ("Provider = Microsoft.Jet.OLEDB.4.0; Password =; User ID = Admin; Data Source =" + HttpContext.Current.Server.MapPath (@ "App_Data\service_applies.mdb") + ";") ;

zhouji700

You cannot use functions or methods in web.config. You can only use absolute strings. You can set a relative path and then stitch it in the program.

askakdk

mark

hawk1979

This is theklongvv.