Update a DataTable using an SQL Statement

[pigeonrandle]

Quite simply, is this possible? I can only find information on
DataTable.Select()

It would be nice if it was :-)
James Randle

[Nick]

pigeonrandle wrote:

Quite simply, is this possible? I can only find information on
DataTable.Select()

It would be nice if it was :-)
James Randle

James,

Depending on the scenario, it's usually better to run the SQL on the
server, and then re-bind the data into your DataTable.

I also imagine it is not possible to alter the contents of a DataTable
using SQL, however, the new C# orcas spec (available from Microsoft's
website) does detail Query expression translation (26.7.1). This is
similar to SQL, which may be of some use to you.

Nick