querying tables in a dataset

Question

I have used a data adapter to build two tables in a single dataset. I cannot find a method to then query these tables to produce a resultant table within the dataset. How can i achieve this?

Administrator · Answer

I assume you generated a dataset with your adapter. The dataset is not filled automatically. In your forms load event place the following code:

OleDbYourDataAdapterName.Fill(YourDataSetName)

Is this what you were looking for?