ASP.NET - Gridview two different datasources

[noob]

Hi All

I want to get data from two different sources, one is an Oracle database and the other is a table in SQL Express and I want to combine this into one gridview. Looking at the following screenshot StudentID, Firstname and Lastname is from an Oracle database and the rest of the data is stored in SQL Express.

I can pull data from Oracle and SQL Express no problem programatically. If it was from the same database I could use a join and if I was using SQL Server 2005 I could look into using a linked server but I'm using SQL Express. This problem has me stumped. Any ideas?


Here's the screenshot

 

[akakjs]

Load both sets as DataTables pop them into the same DataSet, and Setup a datarelation. *

Try this for a quick and dirty start and this msdn reference for something more formal

It's basically a one-to-many relationship join in memory.

akakjs

* Ok there are issues with doing this; like memory usage, updating the data etc. However it sounds like it's what your looking for

 

[noob]

Thanks akakjs. That datarelation looks like it could do the job. I can link the two using StudentID.