471,317 Members | 1,667 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Help with DataSet.Merge()?

I'm having problems with the Merge method. I get two tables into the
dataset after merging. One of them has all of the columns I need but
four of the eight fields are null. The tables look like this:

table1:
personid
firstname
lastname
address
city
state
zip
phone

table2:
personid
statusid
eventid
miscid

I need a table that looks like this:
personid
statusid
eventid
miscid
firstname
lastname
city
state

I do get the above table in a dataset after merging. However, the last
four fields are always null. Why is that?

I have keep changes set to false and add schema enumerator.

Also, will the merge know to match personid in each table so that
records are not duplicated?

Thanks,
Brett

Jan 6 '06 #1
0 916

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Li Weng | last post: by
reply views Thread by Michael Rodriguez | last post: by
2 posts views Thread by Gary | last post: by
2 posts views Thread by Mike Stephens | last post: by
2 posts views Thread by muntyanu | last post: by
4 posts views Thread by Al | last post: by
5 posts views Thread by Mark Chambers | last post: by
2 posts views Thread by Neil Chambers | last post: by
reply views Thread by rosydwin | 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.