Select function to remove rows in datatable that contain certain value

Help
1

Hello, how can I use the select function on a datatable to remove rows that have a value of 0 or an empty string “” in a particular column?
Thank you

2
1 Like
3

Hi @Charmaine_Matsaudza

Use below query to get Nonempty and Nonzero row

dt.AsEnumerable().where(Function(x) not string.IsNullOrWhiteSpace(x(“columnName”).ToString) and not convert.ToInt32(x(“ColumnName”)).Equals(0)).CopyToDataTable

Thanks
Amaresan. P

1 Like
4

Thank you, this helped. But had to change the first condition to “IsEmpty”. Thank you :slight_smile:

1 Like
5

@Charmaine_Matsaudza, please mark reply as solution :slight_smile:

1 Like
6

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