Can you do SQL against local tmp table?

[VB Programmer]

I have a datatable that I have created on the fly. Can I do SQL statements
against it? Such as "SELECT * FROM temptable WHERE xxxx=1"?

 

[W.G. Ryan eMVP]

No, if you mean a System.Data.DataTable object, well not really anyway. The
DataTable has a .Select method that is pretty powerful, a .Compute method
for aggregates and a whole slew of other cool stuff.
http://www.knowdotnet.com/articles/dataviewspart2.html