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
9758 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

What are disadvantages of microsoft-provided data provider classes in ado.net?

0 Answers

What is ado.net objects?

0 Answers

What is openrowset?

0 Answers

What is method to get XML and schema from Dataset? getXML() and get Schema ()