filter with <NULL>

How can I this
dvContratoMaquila.RowFilter = "FechaFinal='<NULL>'"
I need filter all the rows with this field NULL.

thank,

 
miguelmamAsked:
Who is Participating?
 
amyhxuCommented:
if it's from SQL database:

dvContratoMaquila.RowFilter = "FechaFinal Is Null"
0
 
amyhxuCommented:
That worked for me.

Other suggestions are:
 -- Syncfusion
 ' for a numeric null in FechaFinal
     dvContratoMaquila.RowFilter = "IsNull(FechaFinal, 0) = 0"

 -- Microsoft
To return only those columns with null values, use the following expression:
     "Isnull(Col1,'Null Column') = 'Null Column'"

 -- Some discussion
http://www.dotnet247.com/247reference/msgs/30/153129.aspx
 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.