Saturday, October 3, 2009

Filtering columns with NULL values in ADO.NET

In order to return columns with null values from a DataTable, use this expression:

"Isnull(Col1,'Null Column') = 'Null Column'"

If you need more information about filtering data, check out http://www.akadia.com/services/dotnet_filter_sort.html

No comments: