Question

You need to create your own connection string. So you need to know what each of the parts of the connection string mean.

• The connection string needs to know the location where the SQL Server resides, and that's usually a domain name or IP address. This may vary!
• Then you need to know who you are talking to, and that is the name of the server. This is the initial catalog.
• The AttachDbFilename shows the name of the file and the path. Since we want to move the application we use a variable that will represent the path, |DataDirectory|. It actually maps to the App_Data folder.  
• Give the connection string variable a better descriptive name than connectionString. You can't use variable names twice. Definitely don't call it connection string. Some people call it the name of the database and append SQL.
• You will use Integrated Security for class. In a production server you may need to pass a username and password.

1. So your task, is to figure out what your connection string should be and add it to your web.config file.
2. Take a screen shot of your web.config file.
3. In your reply to another students post, comment on the syntax of the other students connection string. Is it correct? If not, what should be fixed?

You'll need this connection string for next week's homework assignment. So this will help you to get ready for next week too.

If you need to verify the connection string, you can drag and drop a SQL Data Source control from the toolbox Data tab to the page, and use the Wizard. It will generate the connection string for you and store it in the web.config file. It's not required, but it is one way to verify your connection string on your system is correct.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Here a new Web Application in asp.net with C# is created using Visual Studio 2017 with name "Demo_WebApplication".This application contains a below connection string in web.config file.

<!--connection string-->
<connectionStrings>
<add name="SalesDBConnectionString"
connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=.\Demo_WebApplications\Demo_WebApplications\App_Data\SalesDB.mdf;Integrated Security=True"/>
</connectionStrings>

Explanation :

• Here name of the connection string is SalesDBConnectionString
• Data Source is the server name which is (LocalDB)\MSSQLLocalDB
• AttachDbFilename is the data database file
• Integrated Security is true means in development environment no need to username and password.

Screen for web.config :

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.