Merging two tables (from different sources) into one

  • Thread starter Thread starter Loke Kit Kai
  • Start date Start date
L

Loke Kit Kai

Hi,

I am retrieving a table (employeeInfo) from active directory, and another
(settings) from sql database. It is a one to one relationship, of course the
relationship does not exist physically. How do i merge the two so that i can
use a datagrid to display the information?

Regards,
Kit Kai
 
Hi Loke,

In a lot of ways, I would make a new datatable, others their own (Ilist)
collection class.

Cor
 
Hi Loke,

You should define the primary key in both DataTable instances.
Put datatables into a dataset.
Call dataset.Merge method to merge the data
See DataSet.Merge Method .net help topic for details.
 
Back
Top