hello,

does anyone know where i can find documentation on what sort of SQL
can be used on the filter & view methods for DataTables?

i see plenty of use of standard statements in use, but im interested
in knowing which helper-methods such as UPPER('foo'), etc...


thanks,
sm

Search .NET SDK document or VS help for "DataColumn.Expression"


"SpaceMarine" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hello,
>
> does anyone know where i can find documentation on what sort of SQL
> can be used on the filter & view methods for DataTables?
>
> i see plenty of use of standard statements in use, but im interested
> in knowing which helper-methods such as UPPER('foo'), etc...
>
>
> thanks,
> sm
>

sm,

For filtering DataTables are the DataView.Filter and the DataTable.Select.

However don't have the mistake that a DataTable is a kind of database. It is
not, it is just an OO class which can be wrapped in a DataSet and uses in
its collections the DataColumn class and the DataRow class.

Cor