I have several grids on one form and these grids are then populated by a query and dataset, adapter each making several connects to the DB. Although they are all populated by the one table, but with differing where clauses. I would like to be able to access the table once take in all its data into the dataset and then query it for each grid, how do I do this?

Thanks

Louisa