StringOrDBNull

This method accepts a string and returns DBNull.Value if the string is null or empty.

public static object StringOrDBNull(string value)
{
    try
    {
        if ((value == null) || (value == String.Empty))
        {
            return DBNull.Value;
        }

        // Made it this far, must have a string
        return value;
    }
    catch (Exception ex)
    {
        Throw ex;
    }

    return null;
}
Author Paul Hayman

Paul is the COO of kwiboo ltd and has more than 20 years IT consultancy experience. He has consulted for a number of blue chip companies and has been exposed to the folowing sectors: Utilities, Telecommunications, Insurance, Media, Investment Banking, Leisure, Legal, CRM, Pharmaceuticals, Interactive Gaming, Mobile Communications, Online Services.

Paul is the COO and co-founder of kwiboo (http://www.kwiboo.com/) and is also the creator of GeekZilla.

Add Comment

Name
Comment
 

Your comment has been received and will be shown once it passes moderation.