LINQ: Remove row only if specific column is empty

[Chirag12]

In my Above table if the “condition” column is empty then dont select it
How do i do this in linq

[Vikas_M]

Hey @Chirag12 ,

Use below linq
YourDT.Rows.Cast(Of DataRow)().Where(Function(row) Not (row("Condition") Is DBNull.Value Or Convert.Tostring(row("Condition")).Trim.Equals(""))).CopyToDataTable()

Hope it helps you

[Anil_G (Anil Gorthi)]

@Chirag12

Please try this

Dt.AsEnumerable.Where(function(x) Not IsNothing(x("Condition")) AndAlso Not String.IsNullOrEmpty(x("Condition").ToString.Trim)).CopyToDataTable

Cheers

[lrtetala (Lakshman Reddy)]

Hi @Chirag12

Try this

filteredRows = dt.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row.Field(Of String)("condition"))).CopyToDataTable()

Hope it helps!!

[Chirag12]

Thank you @Vikas_M ,
It helped me

now i want to get only Used cars details with headers and store it into a new sheet
How do i do it

[Vikas_M]

Hello @Chirag12,
I’m happy the solution worked for you. Could you please indicate the post as the solution and conclude this conversation thread? If you have more questions in the future, feel free to start a new topic.