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  

---

Why is ADO.NET serialization slower than ADO ?

0 Answers   NA,

---

What are the ado.net components?

0 Answers  

---

ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible?

3 Answers   Zensar,

---

What are the steps in connecting to database?

3 Answers   IBM, Microsoft,

---

---

What is DataRowCollection?

0 Answers  

---

How to identify the controls which can be used for binding data?

0 Answers  

---

What does executequery return?

0 Answers  

---

What is the significance of CommandBehavior.CloseConnection ?

0 Answers   NA,

---

What is the difference between SqlCommand and SqlCommandBuilder?

0 Answers  

---

what is connection pooling ?

3 Answers   Vertex,

---

how we can fire event in databound coulm in datagfrid withot using button?

0 Answers   Tech Mahindra,

---