Query in Linq Query

[Mohammad.Fuad]

I was watching a linq tutorial video and following his steps

His linq query looked like this

The purpose of this query is to remove rows whose Country column is empty

I followed his same steps and same query but I am getting an error

Can anyone let me the reason for this error, it would be very helpful.

[rlgandu (Rajyalakshmi Gandu)]

@Mohammad.Fuad

Left side: dtFiltered (a new DataTable variable)=
YourDataTableVar.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row(“Country”).ToString.Trim)).CopyToDataTable

Please try this

[Mohammad.Fuad]

When I used your linq, I got this error

[tazunnisa.badavide (Taj)]

Try this @Mohammad.Fuad
(
From row In dt_1
Where Not String.IsNullOrEmpty(row(“Country”).ToString)
Select row).copyToDataTable

[Mohammad.Fuad]

@tazunnisa.badavide

(
From row In dt_1
Where Not String.IsNullOrEmpty(row(“Country”).ToString)
Select row).copyToDataTable

getting same error

[Shiva_Nikhil]

@Mohammad.Fuad

type the expression manually don’t copy and paste it

(
From row In dt
Where Not String.IsNullOrEmpty(row(“country”).tostring)
Select row
).copytodatatable

cheers

[rlgandu (Rajyalakshmi Gandu)]

@Mohammad.Fuad

LINQ - Filtering out empty rows

Hi @Neal369 Try this ( From currentRow In DataTbl.AsEnumerable Where Not String.IsNullOrEmpty(currentRow(“Country”).ToString) Select currentRow ).CopyToDatatable Hope this helps

[Mohammad.Fuad]

Thanks a lot dude, it worked.

can you tell me why that error occurs?

[Gokul001 (Gokul Balaji)]

Hi @Mohammad.Fuad

Try with expression

(
From row In dt_1
Where Not String.IsNullOrEmpty(row("Country").ToString)
Select row).copyToDataTable

@Mohammad.Fuad

For this error you need to re enter the Double quote in the expression

Regards
Gokul