Can you run SQL statement against a datatable and if so how?

Thanks

george wrote:
You can use the RowFilter property of the DefaultView to narrow down the
number of rows in the DataTable, but if you are looking for aggregates or
some other computation (without making another call to the database), you'll
have to write your own code.

George,

No, there is worked at Linq that will be a kind of query language as SQL
however beter.

Cor

Releasing Excel from memory
Connection.Close or End Using or Both
Building SQL for Fields and Memo-type fields
VS.NET 2003, ADO.NET 1.1 and Access 2000: Getting a Concurrency violation
ReadXMLSchema Doesn't Work