Skip to main content

Steps to attach DataBase to .Net Application - App_Data folder.

Step 1:

Detach Database from SQL Server.
         i) Open Sql Server
         ii) Login to Server
         iii) Select the DB that you going to attach to application, and right click for the option to detach the DB.

Step 2:

Right click on app_data folder and click on add existing item and then select database which you want to add in app_data folder,DB will exist in C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\...

 Step 3:

Alter the your connection string as below:
<connectionstrings>
<add connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DBName.mdf;Integrated Security=True;User Instance=True  " name="ConnectionName" providername="System.Data.SqlClient" />
</connectionstrings>

Comments

Post a Comment

Popular posts from this blog

Python Multi Threading

Speeding up Python code using multithreading A lot of times we end up writing code in Python which does remote requests or reads multiple files or does processing on some data. And in a lot of those cases I have seen programmers using a simple  for loop  which takes forever to finish executing. For example: import requests from time import time  url_list = [     "https://via.placeholder.com/400",     "https://via.placeholder.com/410",     "https://via.placeholder.com/420",     "https://via.placeholder.com/430",     "https://via.placeholder.com/440",     "https://via.placeholder.com/450",     "https://via.placeholder.com/460",     "https://via.placeholder.com/470",     "https://via.placeholder.com/480",     "https://via.placeholder.com/490",     "https://via.placeholder.com/500",     "https://via.placeholder.com/510...
1 comment
Read more

How to encrypt connection string in web.config . In order to not expose connection string to outside world.

Protecting Connection Strings and Other Configuration Information  (C#) Introduction Configuration information for ASP.NET applications is commonly stored in an XML file named  Web.config . Over the course of these tutorials we have updated the  Web.config  a handful of times. When creating the  Northwind  Typed DataSet in the  first tutorial , for example, connection string information was automatically added to  Web.config  in the  <connectionStrings>  section. Later, in the  Master Pages and Site Navigation  tutorial, we manually updated Web.config , adding a  <pages>  element indicating that all of the ASP.NET pages in our project should use the DataWebControls  Theme. Since  Web.config  may contain sensitive data such as connection strings, it is important that the contents of Web.config  be kept safe and hidden from unauthorized viewers. By default, any HTTP re...
Post a Comment
Read more

Books To Refer

1. C#   in Depth ,  Third   Edition : Foreword   by Eric   Lippert        By:  Jon Skeet    Publication Date:  16-SEP-2013 2. Learning jQuery - Fourth Edition     B y:  Jonathan Chaffer; Karl Swedberg     Pub. Date:  June 25, 2013      3.Beginning JSON                    By:  Ben Smith     Publication Date:  04-MAR-2014 4. Responsive Web Design with jQuery     By:  Gilberto Crespo      Pub. Date:  November 25, 2013 5. Developing Responsive Web Applications with AJAX and jQuery       By:  Sandeep Kumar Patel  P ub. Date:  July 25, 2014 6. Dependency Injection in .NET     by  Mark Seemann
Post a Comment
Read more