Cacher is the code snippet organizer for pro developers

            SqlParameter parm2 = new SqlParameter()
            {
                ParameterName = "@CompletedTime",
                SqlDbType = SqlDbType.DateTime,
                Value = isCompleted ? System.DateTime.Now : (object)DBNull.Value
            };