Can i join two C# DataTables on a common column

Question

I have two DataTables dt1 and dt2. Each table have different data in them but they have a common column ReportID.

Is there a way of joining the datatables similar to a SQL Inner Join?

I have tried using DataRelation but it didn't work

Thanks

why did the data relation not work. post some code and the issue you faced. — Mubashir Khan
– Mubashir Khan, Commented Mar 4, 2011 at 12:32

user586254 · Accepted Answer · 2011-03-04 12:34:53Z

1

You could load your data tables into a DataSet and then you are free to create relations and query the data.

http://msdn.microsoft.com/en-us/library/ss7fbaez.aspx

Hope this helps

answered Mar 4, 2011 at 12:34

user586254

Sign up to request clarification or add additional context in comments.

3 Comments

telsokari Over a year ago

thanks for that i did look at Datasets but it was creating a hierachical set i managed to use Linq for it but am now facing an issue of converting my result set into a DataTable to bind to my gridview source var results = from r in dtReports.AsEnumerable() join c in dtReportDetail.AsEnumerable() on r.Field<int>("ReportID") equals c.Field<int>("ReportID") select new List<object>(r.ItemArray).Concat(c.ItemArray); DataTable dtCombineTables = results.CopyToDataTable<DataTable>(); the CopyToDataTable method doesn't get recognised

user586254 Over a year ago

Take a look here blogs.msdn.com/b/aconrad/archive/2007/09/07/…

user586254 Over a year ago

Simple as that: // load into new DataTable DataTable dtCombineTables = result.CopyToDataTable();

Collectives™ on Stack Overflow

Can i join two C# DataTables on a common column

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related