once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?

2 Answers  

---

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

0 Answers  

---

Which is better ole db or odbc?

0 Answers  

---

What are the usages of the command object in ado.net?

0 Answers  

---

What is a database provider?

2 Answers   BioSys,

---

What is the use of Dataview?

0 Answers  

---

Which object holds only data and does not interact with data source?

0 Answers  

---

What is the difference between Command and CommandBuilder object?

0 Answers  

---

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers   Honeywell,

---

Difference between function and trigger?

1 Answers   HCL,

---

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

0 Answers  

---

What is the difference between a Dataset and DataReader? Can dataReader hold data from multiple tables?

3 Answers   Fulcrum Logic, Merrill Lynch,

---