Troy,

OK, sorry, I looked at your code example again and noticed you were pulling from different sources.

However, #1 isn't necessarily disqualified...you 'could' consider a back-end stored procedure in SQL Server to query the FoxTable through ODBC, and do your outer join there. I know some people who have done this.

If you're trying to do the equivalent of an outer join, that also doesn't completely disqualify a relation, though you might have to do some NULL handling. Can you describe the specifics of the outer join and what you want to show in your grid?

Yes, I'd love to see set-based operations in ADO.NET for Whidbey, but I'm not holding my breath. I don't know all the features in Whidbey, but from what I have read, the focus seems to be in other areas. ADO.NET is certainly better than ADO, but still has some gaps. To quote an old professor, it's "just good enough to criticize".

Kevin