i have a dataset with 2 tableadapters in it. each table adapter pulls from a different database on a different SQL server. how can i combine the results from these two tableadapters. (they both "select * FROM" and have getdata() methods. can i call the results from one tableadapter in the other tableadapter somehow? can i create a datatable and merge these two tableadapters somehow? any suggestions? i want to do everything in the dataset designer or the dataset class definition file, not through a windows forms class since i do not want this to be dependent on the page it sits on. thank you.