How to run the Asp.net + SQL Server website

Download the corresponding code of Asp.net + SQL Server and how to make the local machine run properly.

1. the Code Section is directly opened through the vs development environment, mainly Web. config configuration file, <Add name = "dbconnectionstring" connectionstring = "Server = ASUS-14C4E4992D \ sqlexpress; database = register; Integrated Security = true;"/> such as above, connectionstring = server where the server is connected to the database server you configured locally.

2. Deploy the local database. Generally, the database files are in the app_data folder in the Code. The extension is. MDF and LDF.

3. make sure that SQL Server is installed on the local machine. Copy the two databases to the installation path of the local SQL Server. For example, the installation path is C: \ Program Files \ Microsoft SQL Server \ mssql10. under the server name \ MSSQL \ data.

4 ., I have installed SQL 2008. After opening it, right-click the database and choose "Attach Database". The "Attach Database" dialog box is displayed. Select the database to be appended. The path is C: \ Program Files \ Microsoft SQL Server \ mssql10.yxm \ MSSQL \ data.

5. Click OK.

6. return to the Code to view the web. in the config file, append the corresponding server = the name of the server that you have attached to the database, as shown in <Add name = "dbconnectionstring" connectionstring = "Server =. \ Server Name; database = register; Integrated Security = true; "/>

7. The deployment of Asp.net + SQL Server is similar to the above steps.