I'm using two tables from a MySQL db (let's call them db1, db2) and I have to display different views for them that are linked with each other with nested relations (using VS2005 + ADO.NET Connector). What I have been doing till now was adding new table adapters for each different view, many of which contain a lot of IF statement and generally have lot of SELECT "stuff". The problem is that these data have to be updated (currently by pressing an "Update" Button) quite often and this way the loading takes a lot of time... I thought of maybe adding one adapter that takes all the data from the 2 tables and adding different queries, but that doesn't help, cause that way I can't have one DataGridView showing the data grouped by column 1 another showing the data grouped by column 2 and a 3rd one showing all the data, so that all of them can have nested connection and show corresponding data (or at least I don't know of any...) Any ideas of what I should do? (in case you wonder: Group by column1 C= Group By column2 C= db1).