pipelian 0 Newbie Poster
Hi,

i have been trying to combine data from 2 different sources, to make unique rows: here it is my situation

Data in DGV already in dgv, Unbound:

column1 | Qty

"Sugar", 100
"Salt", 100
"Color", 200
"Malto", 150

Data in datatable:

column1 | Qty

"Sugar", 80
"Salt", 60
"Apio", 25
"Lemon", 60
"Color", 60

 So i want a control that matches the column1 in datatable against DGV.Column1, and if value matches only add second column value and if not, then make a new row in DGV.
 Final decided outcome:

 column1 | Qty|Qty2
 "Sugar"| 100  | 80
 "Salt" | 100  | 60
 "Color"| 200  | 60
 "Malto"| 150
 "Apio" |      | 25

Thanks In Advance

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.