Performance Concerns between DataTable and SqlDataReader to fill Data with FlexGrid

Which one is more faster between DataTable and SqlDataReader while I'm try开发者_如何学Going to fill Data into FlexGrid with VB.NET?

---

Depends what are you trying to do, if you just need to get x rows then Reader would be faster but if you will manipulate or want to use caching for result set then go for Data collection of any kind.

---

SqlDataReader is faster as it is readonly forward only. However DataTable is xml based and is slower.

---

SqlDataReader is much faster. It is readonly and you can only forward run on it.

I use readers all the time unless it's an emergency...