Interested to Buy Any Domain ? << Click Here >> for more details...
How to you declare connection strings and how to you make
use of web.config ?
- 3 Answers
- 9781 Views
- MMTS, I also Faced
- E-Mail Answers
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
How to create dynamic gridview?
List the 4 common ado.net namespaces?
What are dcl commands?
What is the difference between DataReader and DataSet in ADO.NET?
How can we add/remove row's in "datatable" object of "dataset"?
Does entity framework use ado.net?
Can we load multiple tables in a dataset?
What is the difference between connected and disconnected environment?
Command objects uses, purposes and their methods.
how can implement dropdownlist in particular of dataset when try to update?
Why do we need ado.net?
What is ado.net components?
Can datareader hold data from multiple tables?
What is an orm, and why would you use one instead of plain old ado.net?
Explain the difference in an abstract class and an interface?
