check for null when using sql data reader

Question

I'm reading data using sql command and sql reader like

using (var reader = command.ExecuteReader())
{
   if (reader.Read())
   {
         // how can I check is reader["Name"] != null?
        myObj.Name = (string)reader["Name"];
   }
}

if (!reader.IsDBNull["Name"]) {

user3559349
– user3559349

2016-11-04 11:16:54 +00:00
Commented Nov 4, 2016 at 11:16 — user3559349
– user3559349, Commented Nov 4, 2016 at 11:16

Chandana Kumara · Accepted Answer · 2016-11-04 11:23:10Z

1

You can use IsDBNull

if(!reader.IsDBNull("Name")){
    myObj.Name = (string)reader["Name"];
}

Unless you can do as:

if (reader["Name"] != DBNull.Value)
{
   myObj.Name = (string)reader["Name"];
}

OR

myObj.Name  = (reader.IsDBNull("Name")? "": sqlreader.GetString(indexofName));

edited Nov 4, 2016 at 11:23

answered Nov 4, 2016 at 11:16

Chandana Kumara

2,6651 gold badge25 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

check for null when using sql data reader

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