title: SQLDataReader how to check for null column values?
body: <p>I am using a SQLDataReader to insert column data into a string[].</p>
  
  <p>However, some of the column values are null. I am a little unsure how to check for this because when I do reader[column_pos] it says the value is "n/a". </p>
  
  <p>What check can I perform so that I could do something like:</p>
  
  <pre><code>for(int i=0; i&lt;myarray.Length;i++){
      if(something){
          myarray[i] = reader[i];
      }
      else
      {
          myarray[i] = "";
      }
  }
  </code></pre>
  
  <p>and insert a blank sting whenver there is a null in the column.</p>