mhinze.com archive

I wanted to set a filter on my DataView so rows with a null value (in my case the STATE column) would be filtered out. This is how I did it:

[csharp]dv.RowFilter = "IsNull(STATE,'null') <> 'null'";[/csharp]

Via this nice article on ADO.NET expressions.

This entry was posted on Monday, December 11th, 2006 at 8:42 am and is filed under .NET, Tips. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.