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.

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

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;

Define table relations?

0 Answers  

---

What is the difference between Command and CommandBuilder object?

0 Answers  

---

How do u implement locking concept for dataset?

2 Answers   ABC,

---

I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...

6 Answers  

---

Define Execute Scalar?

0 Answers   UGC Corporation,

---

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

0 Answers  

---

What are the advantages of ado.net?

0 Answers  

---

i making a project using windows application c#, i want to show user name, password, and one button login. i wanna make it with sealed class .how its possible . when i clicked my login button all project should be open. pls cleare me.

1 Answers  

---

What is difference between connected and disconnected architecture in ado.net?

0 Answers  

---

What is basic use of data view?

0 Answers  

---

What are datareaders?

0 Answers  

---

What are the Data providers in ADO.Net?

0 Answers  

---