Murray Brown
asked on
VB.net Join two data tables
Is it possible to join two data tables?
ASKER
Hi
I want to do a SQL join.
Thanks
I want to do a SQL join.
Thanks
you use a dataview and datarelation object to do so, see here for the starting syntax:
http://msdn.microsoft.com/en-us/library/fa04ha86%28v=vs.110%29.aspx
http://msdn.microsoft.com/en-us/library/fa04ha86%28v=vs.110%29.aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much. I am going to be doing this with a variety of tables
anyhow, first one is to be found easily by checking the Merge method of the datatable.
second one is "easily" with Linq statements, though other methods exists.
of course, if the underlying data is coming from the same database, you could indeed think about doing the "join" in sql directly...