ASP.Net DataView Filter clarification
When i Filter a DataView
someView.RowFilter = "ID<>'A22'开发者_Go百科 and isnull(IsVerified,0)=0"
What is the logic behind isnull(IsVerified,0)=0
?
Does it mean the column IsVerified is null or does it check the column IsVerified not null ?
The IsNull(IsVerified,0)
call checks the IsVerified value for Null, and if it is null, returns 0, otherwise it returns the value of IsVerified. So since it is then comparing that with 0, your row will be selected if IsVerified has the value of 0 or null.
More about IsNull function here.
精彩评论