I found these examples:
dt is a DataTable and it has data, but there are some data that are null, I would like to filter the rows that contain such null data.
number is one of the columns.
I would like to filter and keep all the datatable rows that are not null
dt.DefaultView.RowFilter = "numero <> 'null Column'"; (1)
dt = dt.DefaultView.ToTable();
but I get this error when I try to execute (1)
Unhandled exception of type 'System.Data.EvaluateException' in System.Data.dll
Additional information: The operation '< >' can not be performed in System.Double and System.String.
There is a way to filter and keep the rows that are null
dt.DefaultView.RowFilter = "[numero] is null";
dt = dt.DefaultView.ToTable();
but I want the opposite, that is, NOT to stay with those who are null