How to you declare connection strings and how to you make
use of web.config ?
Answer Posted / d0tnetf0x
In web.config,we have to give connection to database by add
key which is given in application setting tags.as
<appsettings>
<add key="constr" value="Data Source=SQL-PC;Initial
Catalog=sampledb;User ID=sa;password=password "/>
</appsettings>
//under value we have given the database which is connected.
here under ----data source=servername
intial catalog=database name
user id=username of the database(if give)
password= password(optional)
to use this connection we use configsetting or we caneven
directly give it in sqlconnection
sqlconnection conn=new sqlconnection
(configurationsetting.appsettings("constr"))
here constr is the key we added in application settings to
identify it in web.config
[this connection we used by declearing in web.config]
with out declearation:-
sqlconnection conn=new sqlconnection("Data Source=SQL-
PC;Initial Catalog=sampledb;User ID=sa;password=password ")
better process is useing connection by declearing in
web.config
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of ado.net?
What is the difference between Datareader and Dataset?
What are two types of transaction supported by ado.net?
What is the use of sqldatareader class?
What are different layers of ADO.Net?
What is linq and entity framework?
What does adodb stand for?
What is the difference between a datareader and a dataset?
How to identify the controls which can be used for binding data?
What are the data providers used in ado.net
What are the data providers in ADO.NET framework?
Define data adapter?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What do you know about ado.net's methods?
Can we connect two dataadapters to same data source using single connection at same time?