Performance Concerns between DataTable and SqlDataReader to fill Data with FlexGrid

Question

Which one is more faster between DataTable and SqlDataReader while I'm trying to fill Data into FlexGrid with VB.NET?

eugeneK · Accepted Answer · 2009-11-05 11:35:17Z

1

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.

answered Nov 5, 2009 at 11:35

eugeneK

11.2k20 gold badges71 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

IsmailS · Accepted Answer · 2009-11-05 11:34:12Z

1

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

answered Nov 5, 2009 at 11:34

IsmailS

10.9k22 gold badges87 silver badges141 bronze badges

Comments

Faruz · Accepted Answer · 2009-11-05 11:35:58Z

1

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

answered Nov 5, 2009 at 11:35

Faruz

9,94910 gold badges51 silver badges66 bronze badges

Collectives™ on Stack Overflow

Performance Concerns between DataTable and SqlDataReader to fill Data with FlexGrid

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related