How to you declare connection strings and how to you make
use of web.config ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is DataRowCollection?
What is ado.net and its architecture?
How to check if a datareader is closed or opened? IsClosed()
What is an ADO.Net?
How is it possible to get 2 tables of data at a time by using data reader?
Explain the overview of ado.net architecture?
What is bubbled event?
Do we use stored procedure in ADO.Net?
What is the namespaces being used to access oracle database?
What is the difference between sqldatareader and sqldataadapter?
Explain the difference in record set and dataset?
What is the significance of CommandBehavior.CloseConnection ?