Null Values from query in List

Question

I have a Web service that receive one list, in some cases some columns can be null and when I try insert Null values in my List I got a error. "Column is null". How I Can Insert NULL value in list if some column is null??

  dr = cmd.ExecuteReader();
  List<ClientData> myList = new List<ClientData>();
  while (dr.Read())
   {
     ClientData client = new ClientData();
     client.clientId = dr.GetString(0);
     client.ClientName = dr.GetString(1); **---> NULL VALUE**

Tim Schmelter · Accepted Answer · 2016-08-02 09:24:24Z

1

Use DbDataReader.IsDBNull

while (dr.Read())
{
 ClientData client = new ClientData();
 client.clientId = dr.GetString(0);
 if(dr.IsDbNull(1))
     client.ClientName = null; 
 else
     client.ClientName = dr.GetString(1);

answered Aug 2, 2016 at 9:24

Tim Schmelter

462k79 gold badges721 silver badges981 bronze badges

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

Comments

nvoigt · Accepted Answer · 2016-08-02 09:25:12Z

0

You can check if it is null before calling a conversion method:

client.ClientName = dr.IsDBNull(1) ? null : dr.GetString(1);

answered Aug 2, 2016 at 9:25

nvoigt

77.8k28 gold badges103 silver badges156 bronze badges

Collectives™ on Stack Overflow

Null Values from query in List

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related