Hello to all.
Im writing a simple application for the analisys of Data in SQL Database.
Ive created a structure where user can create and save his own query.
The question is:
If user create a query that use only a table and then he create another query that use the previous table joined to another one, and i have the two tables in my dataset, can i execute his query locally?
Example:
I Execute the first two query using a DataAdapter that create a local table Orders and Customers in my dataset.
1) Select * from Orders
2) Select * from Customers
Can I Execute this query locally?
Select * from Customers, Orders Where Orders.CustomerID=Customers.CustomerID
Wich is the ADO.Net object ive to use?
Thanks to all.
Paolo
Im writing a simple application for the analisys of Data in SQL Database.
Ive created a structure where user can create and save his own query.
The question is:
If user create a query that use only a table and then he create another query that use the previous table joined to another one, and i have the two tables in my dataset, can i execute his query locally?
Example:
I Execute the first two query using a DataAdapter that create a local table Orders and Customers in my dataset.
1) Select * from Orders
2) Select * from Customers
Can I Execute this query locally?
Select * from Customers, Orders Where Orders.CustomerID=Customers.CustomerID
Wich is the ADO.Net object ive to use?
Thanks to all.
Paolo
