For loop which delete the duplicate Records

Question

4.00/5 (1 vote)

See more:

HI Everyone,

Nice to See u all.

I am trying to build my logic .I ahve completed the half of the part but i got stuck into this situation.
I am searching for a For loop which delete the duplicate Records.Duplicate records in the sense For Examle:
I have a columns as follows for Excel Sheet name: Employee
Sr.No Name Surname
1 Amit podar
2 Salman khan
3 Amit podar

In this Scenario,I want to read all the records but after reading all records i want to insert only first two records because third records is duplicate that i dont want to insert in database.I want to use for loop for the same.
Kindly advice.
Thanks Harshal

Posted 20-May-14 23:39pm

R Harshal

Add a Solution

Comments

King Fisher 21-May-14 6:11am

Is this Your Task ? either, do you migrating Records from Excel?

R Harshal 21-May-14 6:20am

yes.migrating Records From Excel.

Thanks
Harshal.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

V. · Answer 1 · 2014-05-21T00:04:00

Solution 1

Use a dictionary object. When reading you can check the "ContainsKey" function to see if it was already added or not.

See here[^]

hope this helps.

Posted 21-May-14 0:04am

V.

Comments

R Harshal 21-May-14 7:03am

its so advanced .Actually its good BUt in my requirement there is twist.Is there any other way to get it solve.At the time of reading i want to ignore that duplicate records not at the time of adding.

Thanks
Harshal.

V. 21-May-14 7:58am

Why should you read the value in and delete it afterwards?
You can always do it via two object, read it in a List object and then loop through the list adding to the dictionary object with the ContainsKey check. The List object is the copy of the list and the dictionary object your filtered copy. This is not an advanced object at all...

Nikhil_S · Answer 2 · 2014-05-21T00:13:00

Remove duplicate values through List Contain method

public string[] RemoveDuplicates(string[] inputArray)
{
    List<string> distinctArray = new List<string>();
    foreach (string element in inputArray)
    {
        if (!distinctArray.Contains(element))
            distinctArray.Add(element);
    }

    return distinctArray.ToArray<string>();
}

Delete Duplicate elements through ArrayList Contain method

public string[] RemoveDuplicates(string[] inputArray)
{
    System.Collections.ArrayList distinctArray = new System.Collections.ArrayList();

    foreach (string element in inputArray)
    {
        if (!distinctArray.Contains(element))
            distinctArray.Add(element);
    }

    return (string[])distinctArray.ToArray(typeof(string));

}

appoos · Answer 3 · 2014-05-21T01:34:00

Solution 3

You can loop through the records and check for the existing in the database before inserting.

Posted 21-May-14 1:34am

appoos