Visual Basic Find String in List Of Object

Question

Greeting. I'm currently kinda stuck finding a String in a list of Object (int,string)

I want to check if the String is already contained in the List - if not add it.

The regular <List>.Contains() doesn't work since I am initializing a new Object before inserting it.

Here is my code:

Dim command = New SqlCommand(query, connection)
        Dim reader = command.ExecuteReader()
        While reader.Read

            Dim projID = reader.Item("DB_ID")
            Dim projName = reader.Item("Project")
            Dim proj = New KMProject(projName, projID)
            projList.Add(proj)

        End While
        reader.Close()
 =============================== ProjList having some items already =====================================
        query = ...

            command = New SqlCommand(query, connection)
            reader = command.ExecuteReader()
            While reader.Read

            Dim projID = reader.Item("DB_ID")
            Dim projName = reader.Item("Project")
            Dim proj = New KMProject(projName, projID)
===============Below this section im stuck while verifying if this String is already in the List ===================================
            For Each p In projList
                If projList.Contains() Then
                Else

                    projList.Add(proj)
                End If
            Next

A Friend · Accepted Answer · 2016-08-10 15:31:58Z

1

In my opinion, your best bet here is LINQ :

If Not progList.Any(Function(x) x.Name = "Your string to check") Then
    /*Add the thing*/
End If

Don't forget you have to add the Imports statement:

Imports System.Linq;

edited Aug 10, 2016 at 15:31

A Friend

2,7502 gold badges16 silver badges24 bronze badges

answered Aug 10, 2016 at 15:08

Noémie Lord

7794 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

granadaCoder Over a year ago

Give him the "using"/"imports" statement as well, and I'll upvote it.

granadaCoder Over a year ago

"using System.Linq;" in C#.

Noémie Lord Over a year ago

oh, I see, makes sense indeed

Noémie Lord Over a year ago

DAMN ! I just realised the whole is in VB..... I work so much in both that they are now one and the same.

granadaCoder Over a year ago

Somebody downvoted you. But I'm upvoting now. Give him the case-insenstive string-check-compare and you'll have a great answer.

|

soohoonigan · Accepted Answer · 2016-08-10 15:10:58Z

0

You could use Linq...

For Each p in projlist
    If Not projlist.Any(Function(pl) (pl.ID = proj.ID)) Then prodlist.Add(proj)
Next

(Replace ID with your object's property name)

answered Aug 10, 2016 at 15:10

soohoonigan

2,3602 gold badges12 silver badges18 bronze badges

2 Comments

granadaCoder Over a year ago

Add the using/imports statement he needs........for "Any".....and provide a case insensitive version of the equals check........and I'll upvote.

soohoonigan Over a year ago

@granadaCoder: I didn't include the import statement because the code above will compile without it, and in the OP's post he said proj is Object (int,string), I'm comparing the integer IDs in my answer so case is irrelevant

Collectives™ on Stack Overflow

Visual Basic Find String in List Of Object

2 Answers 2

9 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related