Test for DBNull

[MFRASER]

How do I test for DBNull? The following does not work.
System.Data.DataRow aRow;
if (aRow["ServerName"] != null)

{

aServer = (string)aRow["ServerName"];

}

 

[Nicholas Paldino [.NET/C# MVP]]

MFRASER,

You can check against the static value property of DBNull, like so:

if (aRow["ServerName"] != DBNull.Value)

Hope this helps.

 

[Mike Swaim]

How do I test for DBNull? The following does not work.

Try using .IsDBNull(field);

 

[Michael McDowell]

There's a neat discussion by Dino Esposito that touches on some interesting
issuses associated with reading SQL NULL types in C#.

http://msdn.microsoft.com/vcsharp/default.aspx?pull=/library/en-us/dnaspp/html/datareader.asp

Hope this helps,
Michael McD.

 

[Miha Markic]

Hi,

There is also aRow.IsNull method.