DataView Vs DataTable.Select()
Posted
by Aseem Gautam
on Stack Overflow
See other posts from Stack Overflow
or by Aseem Gautam
Published on 2010-05-14T06:43:46Z
Indexed on
2010/05/14
6:54 UTC
Read the original article
Hit count: 326
Considering the code below:
Dataview someView = new DataView(sometable)
someView.RowFilter = someFilter;
if(someView.count > 0) { …. }
Quite a number of articles which say Datatable.Select() is better than using DataViews, but these are prior to VS2008.
Solved: The Mystery of DataView's Poor Performance with Large Recordsets
Array of DataRecord vs. DataView: A Dramatic Difference in Performance
So in a situation where I just want a subset of datarows based on some filter criteria(single query) and what is better DataView or DataTable.Select()?
© Stack Overflow or respective owner