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

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

Thank you !!


Try below expression before converting it to array.

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

It works well !! Thank you

1 Like

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