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: 302

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

Related posts about visual-studio-2008

Related posts about ADO.NET