How to check for duplicate entries in Data Table - VB.Net

Hello Experts,

I have data table comprised of 3 coulmns (Channel Name, Channel ID, Channel Type)

I'm looking for an efficient VB.net code for looping through the table to detect if I have duplicated channel names.

Someting along the following lines:

For Each drRow in dtChannelsList.Rows
 code goes here to check if drRow.item("ChannelName") is duplicate

Appreciate your help
Hani

 
MehawitchiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
Hi,

Please try following code

For Each drRow In dtChannelsList.Rows
            Dim drs As DataRow() = dtChannelsList.Select("ChannelName='" + drRow("ChannelName") + "'")

            If drs.Length > 0 Then
                'Add Your code here to handle the duplication
            End If
        Next

Open in new window


Thanks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MehawitchiAuthor Commented:
Hello IJZ,

Thank you for the quick response.

I think I should use 1 instead of 0 in the following:
If drs.Length > 0
because there will be already one record for the same name. Right?

0
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
Yes you are right
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.