Query on DataTable

[jcs1953]

I have two queries , one from MSSQL and one from Oracle. The results are combined into one table using "mytable1.Load(dr2)".
My question is can i run a query against mytable1?
If I can't can I populate a table in my SQL database with the data in mytable1 and then run the query? How would I do this?
Thanks

 

[jmeckley]

you can sort and filter the datatable using a dataview. this is similar to creating a view in a database.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190