Yes you can use different databases as well
See this solution or follow the link:
http://forums.asp.net/p/949947/1155679.aspx/1?Re+Using+two+different+databases+with+a+dataset+[
^]
OR
Re: Using two different databases with a dataset?
Dec 30, 2005 09:39 PM|LINK
I just found the answer and it is, YES you can fill a dataset with data from different databases. The following points need to be kept in mind if you are using multiple connections with a single dataset:
Each data adapter needs to be for a single connection.
You can fill a dataset from multiple databases, but while filling a table always use a new data adapter and a new command object for each database.
Give a name to the table you are filling. ex. dataAdapter1.Fill(dataSet1, "table1").
If you recycle the previous data adapter and command objects from the database1 connection to database2 connection, then you cannot populate multiple databases into a single dataset. That is what I noticed while trying to use multiple databases in a dataset.