filter in DataTable.Select

[Guest]

How do I specify the filter for a column with NULL value in
DataTable.Select(filter, sort) function?

string filter = "columnname=NULL"; ?

 

[Kevin Spencer]

IsNull(columnname, replacementValue)

See
http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx
--
HTH,

Kevin Spencer
Microsoft MVP
Chicken Salad Shooter
http://unclechutney.blogspot.com

A man, a plan, a canal, a palindrome that has.. oh, never mind.