Merging datasets based upon primary key

[jaden403]

I have two datasets with nothing in common except for the values in the first column of each (and the columns are named differently) that I am trying to merge and use in a DataGrid.

ds1 looks like:

Col1 Col2 Col3

100 Red Blue

200 Pink Yellow

ds2 looks like:

Column1 Column2 Column3 Column4 Column5 Column6

100 Wood Fire Rain Rocks Flowers

200 Grass Glass Trees People Things

What I am trying to accomplish is this:


100 Red Blue Wood Fire Rain Rocks Flowers
200 Pink Yellow Grass Glass Trees People Things

I know what to do, just not how to do it: that is, loop through each row of ds1. If the value of the first column of ds1 is equal to the value of the first column of ds2, add ds2 to that row in ds1. I have tried many things, but cannot get this to work correctly.

What am I missing?

Thanks!

[Xav]

Just try a loop?

[jaden403]

That's what I had to end up doing.

loop through ds1 rows
loop through ds2 rows
loop through ds1 columns
loop through ds2 columns
look for matching values
copy columns from ds2 in ds1

I just thought there would be an easier way to do that than using nested loops.

[Xav]

Well, if it works, then there shouldn't be too much of a problem. Just make sure that you use the Application.DoEvents() command - that way, it won't jam up the rest of program whilst the program is looping through the hundreds of rows...

It might make it a tad slower, but it's probably worth it to stop the rest of the program freezing. Maybe you could implement a check box labelled "Keep User Responsive" - if it's checked, then use DoEvents(), and if not - well, it's their fault if their computer gums up.