How to

check for DBNull value

Home » Databases » How to check for DBNull value

Published: 26. January 2009 | Updated: 2. November 2011
License: Microsoft Public License (MS-PL)
Categories: Databases
Tags: C# SQL

Snippet shows how to check for database null value

Import namespace

using System.Data.SqlClient;

Code

SqlDataReader reader = command.ExecuteReader(); // get data

// check for DB null
bool isNull = reader["column_name"] == DBNull.Value;

// or

bool isNull = reader["column_name"] == Convert.DBNull;

// or

bool isNull = Convert.IsDBNull(reader["column_name"]);