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

Which database is the ado.net?

962

---

Explain which name space is used to get assembly details?

957

---

What are the major challenges in accessing data from a database?

1014

---

What are the data access namespaces in .NET?

1200

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1014

---

How to pass values into a datatable?

1121

---

What are the objects of ado.net?

1060

---

What is difference between executequery and executeupdate?

985

---

Define the executescalar method?

934

---

What is ado.net explain with diagram?

953

---

What is an ado?

978

---

What is the maximum pool size in ado.net connection string?

936

---

How to check if the Dataset has records ?

999

---

What is sqldatareader in ado.net?

911

---

differance between ADO vs ADO.Net?

1052

---