Checking null value for integer from DataBase

Question

I have a student table that references a parent table, as a FK. But a student can be older than 18, in which case he's responsable for himself and the parent_id is set to null. I have to check if the id is null, but:

if (dtreader_resp.Read())
            {
                if(dtreader_resp.GetInt16("resp_id") != null)
                {
                    resp.Resp_id = dtreader_resp.GetInt16("resp_id");
                }
            }

Always returns true. Is there a way to check if that field is null?

Christian Gollhardt · Accepted Answer · 2017-02-01 23:44:58Z

1

You could use IsDBNull or use a nullable int:

var data = sqlReader["resp_id"] as int?;
if (data.HasValue)
{
    var actualValue = data.Value
}

answered Feb 1, 2017 at 23:44

Christian Gollhardt

17.1k17 gold badges83 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Checking null value for integer from DataBase

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related