tags:

views:

186

answers:

3
Q: 

Performance Concerns between DataTable and SqlDataReader to fill Data with FlexGrid

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

+1  A: 

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

Ismail  2009-11-05 11:34:12
Thanks a lot Ismail S.
RedsDevils  2009-11-05 11:39:04
+1  A: 

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.

eugeneK  2009-11-05 11:35:17
Thanks a lot eugenek!
RedsDevils  2009-11-05 11:38:21
+1  A: 

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

Faruz  2009-11-05 11:35:58

related questions

Best way to get a comma delineated string into xml format?
Table NewRow() Causes Memory Leak
Querying DataColumnCollection with LINQ
Compare datatables
.NET DataTable skips rows on Load(DataReader)
OOP and DataTables for Rank Amateurs
"Endless scrolling" effect in a HTML table
How do you convert a DataTable into a generic list?
How do I display only certain columns from a data table?
Getting Count from Grouped DataTable in VB via Linq
DataTable + DataGrid Data Binding Performance Againsts Custom Data Source Object + Data Grid
.NET Fastest way to iterate through rows in a datatable?
Cast or convert when retrieving data from a database?
How can I make a globally accessible datatable in a Winforms application?
DataGridView's bound table only generates one RowChanged event on a double-click. How do I make it do two?
Abstracting storage data structures within XPath
Speed of DataSet row/column lookups?
How do I bind the result of DataTable.Select() to a ListBox control?
How many DataTable objects should I use in my C# app?
Trigger update on DataTable bound to DataGridView
DataTable to readable text string
.Net - Returning DataTables in WCF
Datatables, Dataviews and distincts! (ASP.Net/VB)
Datatable vs Dataset
Check for changes to a SQL table?