471,072 Members | 1,556 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Duplicate rows need to identify & store in seperate DataTable usin


I have a DataTable with several rows. Its having 20 Columns. when i click
the Insert button then i have to check the Database Rows. Whether these new
rows are already available in the Database. If its there, then i need to
seperate the Duplicate Records

Based upon 4 columns(EmployeeID, ProjectName, ProjectType, StartTime --
should be activate as a Composite Primary key)

and store those duplicate records into seperate DataTable and insert the
Non-Duplicate records into the Database. I need a seperate function. Because
I have to check the duplicate records with database as well as within the
DataTable. The DataTable may have duplicate records.

Please Help.

Aug 31 '06 #1
0 1948

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by John Steen | last post: by
18 posts views Thread by Elroyskimms | last post: by
6 posts views Thread by 6thirty | last post: by
4 posts views Thread by Vijay Pote | last post: by
1 post views Thread by Jon | last post: by
3 posts views Thread by afr0ninja | 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.