query a dataset

[Droomgans]

Hi everybody

I have a large and pretty complex XML file that I read in a dataset.
so now my dataset has several tables, all linked and pretty cool

but is there a possibility to create a sql-query on the datatables from that dataset?
because a datatable is kinda like a table on a database so I guess that is must be possible, but I don't know how !
so any help is appreciated

thanks in advance

and a happy newyear to everybody

grtz

 

[giadich]

yes you can filter table. look in the intellisense for something like datatable.select

sorry i can't remember off the top of my head.

 

[Droomgans]

Hi thanks for the answer
but can I use a filter to query different datatables that have relationships ?

I thought a filter was any applicable to one datatable?
or am I wrong here?

 

[giadich]

you can create views out of the tables and operate on the views