Remember "null" is not the same as "DBNull"

Posted: 15-12-2008 | Author: flexicoder | Category: C# 3.5, SQL Server

When supplying null values to stored procedures, remember that you have to set the value to DBNull…

if (_UserId == null)
{
    cmd.Parameters.Add(new SqlParameter("@UserId",System.DBNull.Value ));
}
else
{
    cmd.Parameters.Add(new SqlParameter("@UserId", _UserId));
}


Category: C# 3.5, SQL Server by flexicoder

Leave a Reply