[CLOSED] Can you perform a select query against the Dataset?

[Venus]

I have 2 tables in my dataset and want to create a select statement against the two tables with a join, creating yet a third table in my dataset. The key here, I want to do it AGAINST the cached Dataset and NOT the server.

I want the user to play with the numbers and see the results on the screen and when they're happy THEN they click save and the data goes to the server. I know how to do this in a function that loops record by record I was hoping I could just do a select on the two tables in the dataset and storing the results in a third. Can you do a select & join against a Dataset?

Thanks

[riteshjain1982]

you should look for DataRelation object

[FunkyDexter]

A datatable within a dataset has a select method. Could you use that?

E.g.
MyDataSet.MyDataTable.Select(field=value)

[Venus]

The relation object I don't believe is something I can use I have a many to many relationship (child to child) I want to display in the same datagridview, one of the columns is calculated. It's really easy to do in SQL against server databases but I don't know how I'd do it against a cached Dataset instead with the two individual tables loaded seperately in that dataset I'd like to add a third table that joins them. I've researched it long enough, a Dataset isn't a Database you can filter & use expression columns but far as I can see you can't run a simple select statement against a dataset trying to "join" two seperate tables, you have to create the joined table manually.

Thanks!