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...