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.Def aultView;
dv.RowFilter = "FirstField LIKE 'whatever%'"
"TA" <[e-mail]> wrote in message
news:e1******** ******@TK2MSFTN GP09.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.Selec t 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.Selec t, otherwise
I normally use the DataView.

Hope this helps
Jay

"TA" <[e-mail]> wrote in message
news:e1******** ******@TK2MSFTN GP09.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.Selec t("Name like '%rob%'");

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

TA,
In addition to the DataView as William stated, you can also use the
DataTable.Selec t 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.Selec t, otherwise I normally use the DataView.

Hope this helps
Jay

"TA" <[e-mail]> wrote in message
news:e1******** ******@TK2MSFTN GP09.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.Expr ession.

http://msdn.microsoft.com/library/de...ssionTopic.asp

Hope this helps
Jay

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

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

"TA" <[e-mail]> wrote in message
news:e1******** ******@TK2MSFTN GP09.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