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

Explain the two fundamental objects in ado.net?

906

---

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2332

---

What is ado in agriculture?

888

---

What does ole stand for in excel?

1062

---

What is difference between executequery and executeupdate?

922

---

How is entity framework different from ado.net?

904

---

What is dao and ado?

878

---

What is ado.net full form?

935

---

Which parameter of ConnectionString is used to specify the name of the database?

985

---

What is the difference between an ADO.NET Dataset and an ADO Recordset?

990

---

How can I retrieve two tables of data at a time by using data reader?

932

---

Which is faster ado.net or linq?

953

---

What is serialization and de-serialization in .net? How can we serialize the dataset object?

906

---

What are the benefits of ADO.NET?

1061

---

What is disconnected data?

977

---