Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 6B908632ABA for ; Tue, 3 Aug 2010 12:26:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 16507-10 for ; Tue, 3 Aug 2010 15:26:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from jupiter.marktest.pt (delta.marktest.pt [80.251.174.116]) by mail.postgresql.org (Postfix) with ESMTP id DDF2A6327CB for ; Tue, 3 Aug 2010 12:25:59 -0300 (ADT) Received: from Proteu (proteu.marktest.pt [10.61.90.54]) by jupiter.marktest.pt with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id P5AX6V91; Tue, 3 Aug 2010 16:25:57 +0100 Message-ID: <1BBEE93EA22B44CF870E6F37B350FF59@marktestcr.marktest.pt> From: "Oliveiros d'Azevedo Cristina" To: Subject: Detecting a Null field on an NpgsqlDataReader object Date: Tue, 3 Aug 2010 16:25:57 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0023_01CB3328.8D7032C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.791 tagged_above=-5 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/1 X-Sequence-Number: 6929 This is a multi-part message in MIME format. ------=_NextPart_000_0023_01CB3328.8D7032C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear All, How can I detect if a certain field of a record returned by a query is = NULL ? I'm sure there must be a direct way of doing this, but I googled up and = down, back and forth and was unable to find out. For ex, in Sql Server we just compare with DbNull singleton.=20 What is the equivalent in Npgsql? Thanks a million for your help Best, Oliveiros d'Azevedo Cristina ------=_NextPart_000_0023_01CB3328.8D7032C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear All,
 
How can I detect if a certain field of = a record=20 returned by a query is NULL ?
 
I'm sure there must be a direct way of = doing this,=20 but I googled up and down, back and forth and was unable to find=20 out.
 
For ex, in Sql Server we just compare = with DbNull=20 singleton.
 
What is the equivalent in = Npgsql?
 
Thanks a million for your = help
 
Best,
Oliveiros d'Azevedo=20 Cristina
------=_NextPart_000_0023_01CB3328.8D7032C0--