|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
filter in DataTable.SelectHow do I specify the filter for a column with NULL value in
DataTable.Select(filter, sort) function? string filter = "columnname=NULL"; ? IsNull(columnname, replacementValue)
See http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx -- Show quoteHTH, Kevin Spencer Microsoft MVP Chicken Salad Shooter http://unclechutney.blogspot.com A man, a plan, a canal, a palindrome that has.. oh, never mind. "Roy" <R**@discussions.microsoft.com> wrote in message news:C2B1F5DE-6F86-4957-B65F-D00A1A437311@microsoft.com... > How do I specify the filter for a column with NULL value in > DataTable.Select(filter, sort) function? > > string filter = "columnname=NULL"; ?  |
|||||||||||||||||||||||
Other interesting topics