471,348 Members | 1,349 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,348 software developers and data experts.

How does .Merge() coordinate?

If I have a dataset with one table and want to merge another table, how
does merge know which column to match rows on in each table?

For example

Table 1:
personid
firstname
lastname
address
city
state
zip
phone

Table 2:
personid
statusid
passid
eventid

It should match personid in each table and add the missing columns and
data to one of the tables. When I do this:

DSone.Tables["tableone"].Merge(DStwo.Tables["tabletwo"], false,
MissingSchemaAction.Add)

The first table in the DSone table collection has 8 columns. The first
four columns have data and the last four are null.

Is any of the above something merge can do or should I be using
something different?

Thanks,
Brett

Jan 6 '06 #1
0 887

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sebastian Luemmer | last post: by
8 posts views Thread by Squirrel | last post: by
1 post views Thread by OtisUsenet | last post: by
reply views Thread by peradino | last post: by
9 posts views Thread by Eric.Gabrielson | last post: by
12 posts views Thread by Petra Rohmer | last post: by
1 post views Thread by Ronak mishra | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.