0

I have got My 1st DataTable TableA from Database which is given below

Item       Place
  -------------------------
      ItemA      PlaceA
      ItemC      PlaceC

I have got My 2nd DataTable TableB from Database which is given below

Item       Status
---------------------------
      ItemB     
      ItemC      Complete

The New Data Table will Look Like Below

Item      Place       Status
-------------------------------------
     ItemA     PlaceA  
     ItemB                 Complete
     ItemC     PlaceC      Complete

I am Using the following Code

Dim DT_A As DataTable
        DT_A = TableA.Copy()

        Dim DT_B As DataTable
        DT_B = TableB.Copy()

        DT_A.Merge(DT_B)

I am Getting Like below

Item      Place       Status
-------------------------------------
     ItemA     PlaceA  
     ItemB                 Complete
     ItemC     PlaceC      
     ItemC                 Complete

But I am not Getting the Like Below Data Table

Item      Place       Status
-------------------------------------
     ItemA     PlaceA  
     ItemB                 Complete
     ItemC     PlaceC      Complete

Please Help.What is the Main Problem and Whats the Solution

Thanks in Advance

Edited by Ezzaral: Fixed code tags.

3
Contributors
2
Replies
4
Views
5 Years
Discussion Span
Last Post by Netcode
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.