Using DataTable's Select method to find null values RSS

• • Reply
  

  futbolstar

  Member

  15 Points

  3 Posts

  Using DataTable's Select method to find null values

  Sep 29, 2004 07:57 PM|LINK

  I'm trying to use the DataTable's Select method to find null values. My code looks like this:

  dataTable.Select("FieldName=NULL")

  The dataTable object has null values but nothing is ever returned (Length=0). How do I write the filterExpression parameter to retrive null values? Thanks
• • Reply
  

  ndinakar

  All-Star

  49092 Points

  6868 Posts

  Moderator

  MVP

  Re: Using DataTable's Select method to find null values

  Sep 29, 2004 11:46 PM|LINK

  check against system.dbnull.value

  'if dr is the datarow
  if not dr("columnname") is system.dbnull.value then
    'do your stuff
  end if

  you can also do something like

  if not IsDbNull(dr("column")) then
     ' do your stuff.
  end if
  

  hth
  ***********************
  Dinakar Nethi
  Life is short. Enjoy it.
  ***********************
• • Reply
  

  RemithR

  Contributor

  2376 Points

  396 Posts

  Re: Using DataTable's Select method to find null values

  Apr 22, 2009 07:06 PM|LINK

  Please use:

   dataTable.Select("FieldName is NULL")

  this will give you the DataRows with null values in FieldName column.
  

  • Edited by RemithR on Apr 22, 2009 09:32 PM
  • Edited by RemithR on Apr 23, 2009 12:33 AM
  • Marked as answer by XIII on Dec 09, 2012 07:51 PM