Local Query

[basapa]

Hello to all.

I'm writing a simple application for the analisys of Data in SQL Database.

 

I've 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 i've to use?

Thanks to all.

 

Paolo

[archer_coal]

by locally you mean you do not want to re-querey the database?

and do you have a reference to Imports System.Data.OleDb?

[basapa]

Yes

[archer_coal]

right click your dataset and choose view schema, this will display your table and XML for the tables

if you know XML at all, you can manipulate the data being stored there any way you like.

[quwiltw]

Add a relation in the dataset, then you can get at the orders through GetChildRows().