LINQ c# remove all rows with empty or null values

[Hazem_Saleh]

Hello all
I found alot of LINQ syntax but all in VB not in C# how i can remove all rows who have empty or null values
without mention the column name ?

And with mention the column name?

[arjunshenoy]

Hi @Hazem_Saleh

Try using the following query:

var filteredRows = originalTable.Rows.Cast<DataRow>()
                                    .Where(row => row.ItemArray.All(field => !string.IsNullOrWhiteSpace(field.ToString())))
                                    .CopyToDataTable();

Hope this helps,
Best Regards.

[arivu96 (Arivazhagan A)]

Hi @Hazem_Saleh,

use below syntax to get not null rows for particular column

dt=dt.Select("ColumnName <>''").CopytoDataTable()

use below syntax to get not null rows for All column

DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable()

Regards,
Arivu

[Hazem_Saleh]

Thanks for answering,
OF datarow seems a an issue here

[arivu96 (Arivazhagan A)]

fetchDataDT should be in To value

Regards,
Arivu

[ppr (Peter)]

@arivu96

Cast(Of DataRow)

@arivu96

Where(Function(row)

… are keywords of VB.Net languague

When your topic title is still valid then you are looking for C# Statements:

@Hazem_Saleh

I found alot of LINQ syntax but all in VB not in C#

So what is finally needed C# or Vb.Net?