title: Handle NULL in Datareader
body: <p>This is the code I' using for reading data from sql through DataReader. It gives Error when there is a NULL in table. How to handle it?</p>
  
  <p>I tried </p>
  
  <pre><code>c.ActualWeight= dr[0] as float? ?? default(float);
  </code></pre>
  
  <p>The problem with this is that it is successful in Handling NULLs but the result is Always 0 even if the sql database has value 1 in that field.</p>
  
  <pre><code>{ 
      List&lt;Inventory_Connector&gt; LC = new List&lt;Inventory_Connector&gt;();
      string ConString = "data source=DELL\\SQLSERVER1;Initial Catalog=Camo;Integrated Security=True";
      SqlConnection con = new SqlConnection(ConString);
      SqlCommand cmd = new SqlCommand("Select Top 17 * from Inventory_Connector", con);
      con.Open();
      SqlDataReader dr = cmd.ExecuteReader();
  
      while (dr.Read())
      {
          c.ActualWeight = float.Parse(dr[0].ToString().Trim());
      }
  
      LC.Add(c);
  }
  
  dr.Close();
  con.Close();
  return LC;
  </code></pre>