<?xml version="1.0" encoding="utf-8"?>
<configuration>
<system.web>
<authorization>
<allow users="admin" />
<deny users="?" />
<deny users="*" />
</authorization>
</system.web>
</configuration>
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;Database=www.qsh.eu_8a547bfd-ce62-405a-bbfe-1628ac48aa15;AttachDBFilename=|DataDirectory|ASPNETDB.MDF" />
</connectionStrings>
For examle you have database "Test.mdf" created at SQL Server Management Studio Express.OR
1st step: your database must be detached from your SQL server correctly: open management studio -> right click on "Test" database -> Tasks -> Detach.
2nd step: create folder www/App_Data and copy Test.mdf without log file.
3 step: generate connection string at https://www.qsh.eu/admin/EditFreehosting.aspx and save in web.config.
4 step: replace name="LocalSqlServer" with (for example) name="DBAccess".
5 step: in code you can read connection string from web.config:
string connectionString = ConfigurationManager.ConnectionStrings["DBAccess"].ConnectionString;
IDbConnection connection = new SqlConnection(connectionString);
Dim SQLData As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\db.mdf;Integrated Security=True;User Instance=True")
Dim SQLData As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("from
dbConnectionString").ConnectionString)
文章
所有留言
