数据库在App_Data文件夹下
在配置文件中:
<connectionStrings>
<add name="connstr" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
.cs类中:
private static string dbConnectionString
{
get
{
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if (!dataDir.EndsWith(@"App_Data"))
{
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir+"App_Data\\");
}
return ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
}
}
winform 类中:
private static string dbConnectionString
{
get
{
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
return ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
}
}