DataTable - what SQL does it support? -- dotnet ado.net

SpaceMarine
10/11/2007 11:16:05 AM

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

Norman Yuan
10/11/2007 2:20:53 PM

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

[quoted text, click to view]

Cor Ligthert[MVP]
10/12/2007 12:00:00 AM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet ado.net

dotnet ado.net : DataTable - what SQL does it support?