two different data sources to one gridview how?

[cesaru]

I want to union to different table from two different datasources one is an informix db and the other an Sql Express db.

The two tables are not the same but they share common columns.

any ideas will be greeeeeat!

thank you very much!

 

[ca8msm]

You could use a DataSet, load one set of data into the first DataTable and one into the second, and then set up relationships between then.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[cesaru]

Thanks! I found this good example for anybody who is looking for the same thing.

http://home.hot.rr.com/graye/Articles/DataTableJoins.htm

but I wonder if for my case the following could be simpler.

I have my sqlexpress db with some data and I wanted to related to a informix db.

is it easier,faster if I import the informix table to a temp table in my sql server then just do a reqular query there?

thanks for all your help.

 

[jbenson001]

The way you suggested is the way I would go about doing it. It would definately be faster, and easier, coding wise.