How to remove empty rows by using linq query

Help Studio
, ,
1

how to remove empty rows by using linq query

image

2

@chowdaryharitha55

use this Linq

nonEmptyRows = data.Where(row => !string.IsNullOrWhiteSpace(row)).ToList();

3

Hi @chowdaryharitha55

Use this query to store the data without empty rows

dt = dt.AsEnumerable().Where(Function(row) Not row.ItemArray.All(Function(field) String.IsNullOrWhiteSpace(field.ToString()))).CopyToDataTable()

or

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

4

@chowdaryharitha55

hi

try this

datatable.asenumerable.where(function(x) not string.isnullorempty(x(“codes”).tostring)).copytodatatable

5

@chowdaryharitha55

dt_2.AsEnumerable.where(function(x) not x("codes").equals("")).CopyToDataTable

image
image753Ă—538 5.85 KB

1 Like
6

@chowdaryharitha55

dt.AsEnumerable.Where(Function(r) not string.IsNullOrEmpty(r(0).ToString)).CopyToDataTable

image
image551Ă—532 13.5 KB

refer this

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.