Querying a DataSet (multiple Tables) - No attached Database.

I have two tables in a dataset, which are both filled when the user opens a source file.

One table contains customer names, the other contains transaction information

I want to display a datagrid/datagridview of all customers who have transactions records between a certain date.

All the records are in each table and linked via a relationship (customer account code)

I can't work out how to generate a query without using a seperate database.

At this stage a seperate database is not a viable option.

Can anyone help please

michaelv
Just a filter

I'll have a play around, but could you possibly give me an example
Robinson
If I understand correctly what you're asking, I think all you need to do is set up a filter on the DefaultView of the Customer table.
Babba72

MyCustomerTable.DefaultView.RowFilter = "MyDate > Date1 AND MyDate < Date2"

You might have to tweak this a bit ... not sure off the top of my head how to represent the dates in the filter string. Play with it and see if it gets you what you need.
Querying a DataSet (multiple Tables) - No attached Database.