How to you declare connection strings and how to you make use of web.config ?

How to you declare connection strings and how to you make
use of web.config ?

Question Posted / deepa

3 Answers
9944 Views
MMTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to you declare connection strings and how to you make use of web.config ?..

Answer / prasad

In web.config file just plase

<appSettings>
<add key="ConStr" value="Provider=SQLOLEDB.1;User
ID=sa;Initial Catalog=Sample;Data Source=ABC"></add>
</appsettings>

and in CS file

sqlconnection con = new sqlconnection
(ConfigurationSettings.AppSettings["ConStr"]);

and u can u this connection any where in ur App.

Is This Answer Correct ?

4 Yes

0 No

How to you declare connection strings and how to you make use of web.config ?..

Answer / 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

How to you declare connection strings and how to you make use of web.config ?..

Answer / ansu kumar

in
web.config file
<appsetting>
<add key="constr" value="data source=database name;
database=database name"/>
</appsetting>

and
in .aspx file
string str=configurationsetting.appsetting.constr;

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More ADO.NET Interview Questions

Diff. b/w DataReader and DataSet?

8 Answers Avon, Value Labs,

How to check if a datareader is closed or opened?

1 Answers

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers

What are the advantages and disadvantages of using datalist?