开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜