How to exclude "Null" and "0" and store to Array variable?

Help Activities
, ,
1

Hello, all

I’d like to store value which has value. How can I configure it?
Currently, it’s unable to exclude “Null” and “0” .
Dt_keyword.AsEnumerable().Select(Function(a) a.Field(Of String)(“Name”).ToString).ToArray

image
image1061×397 14.2 KB

Thank you !!

2

@Dorothy_lee

Try below expression before converting it to array.

            Dt_keyword = Dt_keyword.Select("Name <> 'Null' or Name <> '0'").CopyToDataTable
2 Likes
3

It works well !! Thank you

1 Like
4

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