difference between writing connection string in web.config
through connection string and appsettings
Answers were Sorted based on User's Feedback
Answer / ramesh p
Introduction
In many cases, we need to use some data string throughout
the application, database connection string is the best
example of it. Instead of writing the connection string
wherever we are creating a connection, its good practice
(and easy to maintain too) to store it into web.config file
and get it at desired place.
Places to store data into Web.Config file
There are two places where we can store data into our
web.config file. These are appSettings and
connectionStrings. Following is the code snippet from the
web.config file where we can store data and retrieve at
later point of time.
<configuration>
<appSettings>
<add key="ConnStr" value="Data
Source=.\SQLEXPRESS;AttachDbFilename=C:\MyData\App_Data\Database.mdf;Integrated
Security=True;User Instance=True"/>
</appSettings>
<connectionStrings>
<add name="ConnStr" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=C:\MyData\App_Data\Database.mdf;Integrated
Security=True;User Instance=True"/>
</connectionStrings>
</configuration>
Here appSettings is meant for any data string that can be
stored while connectionString is meant for storing the
database connection strings only.
How to Get data from Web.Config
Getting data from web.config file is simple. If you want to
get data from appSettings tag then you need to write
following code
string connStr =
System.Configuration.ConfigurationManager.AppSettings["ConnStr"].ToString();
To get data from web.config file stored under
connectionStrings tag, you need to write following code
string connStr =
System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"].ToString();
Getting connectionStrings value into .aspx page
If for some reason you want to access the string stored in
connectionStrings tag into .aspx page (You may need this
while using SqlDataSource control), you need to write
following code (Notice the code in the pink color <%$
ConnectionStrings:ConnStr %>).
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString='<%$ ConnectionStrings:ConnStr %>'
SelectCommand="Select * FROM SampleForTutorials ORDER BY
[Name]" DataSourceMode="DataSet">
</asp:SqlDataSource>
Conclusion
Web.Config file is the best place to store small and simple
string that can be used throught the application. Using
System.Configuration.ConfigurationManager class that exists
in System.Configuration namespace, we can retrive them
wherever we need.
Is This Answer Correct ? | 27 Yes | 3 No |
both section are used for describing database strings and
values .This is used throughout our project if we using web
applications.
Is This Answer Correct ? | 9 Yes | 3 No |
What are the objects in used in ASP for processing input and outputs?
Which @page directive should you create an asynchronous page?
How do you declare static variable? What is its lifetime?
How to configure a website without using IIS.
What is the use of execute non query in asp.net?
What are the new login controls in asp.net 2.0?
Define common type system?
Explain form level validation and field level validation?
How to add DateTime Control in normal DataGrid Server Control?
i develop a web application and i gave security setting i.e autherization and athentication now it work properly on my local system , now question is ,is this security setting ie autherization and athentication which i gave in web.config will it be enough strong to secure my application on internet or i have to use some 3rd party tool or software to get security .if yes --how ? if no--what is the alternate?
What is clr? Difference between clr & cts?
What is the use of express session?