VB.net Ado.net Trying to display data from two different database types: I am new to VB.net. I am trying to pull data from a SQL Server database and also a Microsoft Access database and display this information in a datagrid like control. I can pull from either database separately, but do not see how to combine them. I want to display the data like the following: Note this is readonly data. I do not need to edit this data. Cust# Name Cases Followup -------- --------- --------- ------------- 1234 Joe's 10 Yes 2222 Tony's 0 No The 1st 2 columns are pulling from SQL Server just fine. I would like to pull the 2nd two columnds from Microsoft Access. I am using Jet 4.0 and Oledb to connect here. Can someone describe how to accomplish the above. All the book examples I see are showing how to pull data from only one database type at a time. Thank you for your time and help.
It appears to me that you would need 2 separate Datasets to do what you're looking for. One populates your information from Access, the other from SQl, then you would call the DataSet.Merge method from either of those datasets to bring them together into one. After that you should be able to display your information.
