DataTable filtering (Like)

[TA]

Hi,

Does anyone know if it is possible to filter rows in a DataTable by pattern
(e.g. Like in SQL)

For instance I want to select all rows containing the 'rob' in the name
column.

Any ideas?
- TA

 

[William Ryan eMVP]

Yes, you can use a dataview and set it's rowfilter.

DataView dv = myDataTable.DefaultView;
dv.RowFilter = "FirstField LIKE 'whatever%'"

 

[Jay B. Harlow [MVP - Outlook]]

TA,
In addition to the DataView as William stated, you can also use the
DataTable.Select method to return an array of DataRows.

The biggest difference being is the DataView is bindable, while the Select
is not.

If I need the rows in a For Each I normally use DataTable.Select, otherwise
I normally use the DataView.

Hope this helps
Jay

 

[TA]

found it
like really exists
e.g. dataTable.Select("Name like '%rob%'");

 

[TA]

Thanks guys,
Appreciate teh Help

TA,
In addition to the DataView as William stated, you can also use the
DataTable.Select method to return an array of DataRows.

The biggest difference being is the DataView is bindable, while the Select
is not.

If I need the rows in a For Each I normally use DataTable.Select, otherwise
I normally use the DataView.

Hope this helps
Jay

 

[Jay B. Harlow [MVP - Outlook]]

TA,
FYI: The syntax that ADO.NET supports for Expressions (such as those passed
to
Select & Compute) is documented under DataColumn.Expression.

http://msdn.microsoft.com/library/d...fSystemDataDataColumnClassExpressionTopic.asp

Hope this helps
Jay