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%'"
"TA" <[e-mail]> wrote in message
news:e1**************@TK2MSFTNGP09.phx.gbl...

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

[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" <[e-mail]> wrote in message
news:e1**************@TK2MSFTNGP09.phx.gbl...

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

[TA]

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

"TA" <[e-mail]> wrote in message
news:e1**************@TK2MSFTNGP09.phx.gbl...

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

[TA]

Thanks guys,
Appreciate teh Help

"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:Oh**************@tk2msftngp13.phx.gbl...

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" <[e-mail]> wrote in message
news:e1**************@TK2MSFTNGP09.phx.gbl...

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

[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/de...ssionTopic.asp

Hope this helps
Jay

"TA" <[e-mail]> wrote in message
news:Ov****************@TK2MSFTNGP12.phx.gbl...

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

"TA" <[e-mail]> wrote in message
news:e1**************@TK2MSFTNGP09.phx.gbl...

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