Linq to search the value in dataset

Question

0.00/5 (No votes)

See more:

I have a dataset and I would like to know if there is a part of value in certain column exists.

What I have tried:

VB

Dim str as string = "Apple"
Dim contains As Boolean = ds.Tables("result").AsEnumerable().Any(Function(row) str= row.Field(Of [String])("COL1"))

This gives me true of false which is what I want.
but If my column has

Applea
AppleB

it should return true. Meaning it has to search for "Contains" instead of exact word.

Posted 4-Feb-16 8:53am

sudevsu

Updated 4-Feb-16 9:25am

Chris Maunder775.8K

v2

Add a Solution

2 solutions

Solution 2

There actually is a String-method "Contains(..)" :-)

String.Contains Method (String) (System)[^]

VB

Dim contains As Boolean = ds.Tables("result").AsEnumerable().Any(Function(row) row.Field(Of [String])("COL1").Contains(str))

Posted 4-Feb-16 9:16am

Sascha Lefèvre

Add a Solution

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

Richard Deeming · Accepted Answer · 2016-02-04T09:12:00

So what's wrong with using the Contains method?

VB.NET

Dim str as string = "Apple"
Dim contains As Boolean = ds.Tables("result").AsEnumerable().Any(Function(row) row.Field(Of [String])("COL1").Contains(str))

Or, if you want a case-insensitive comparison:

VB.NET

Dim str as string = "Apple"
Dim contains As Boolean = ds.Tables("result").AsEnumerable().Any(Function(row) row.Field(Of [String])("COL1").IndexOf(str, StringComparison.OrdinalIgnoreCase) <> -1)

Linq to search the value in dataset

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Linq to search the value in dataset

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us