title: Remove column from datareader
body: <p>I have a small C# function that takes any generic SQLDataReader and converts it to a csv file. However I now need to ignore 1 column from a datareader that gets passed into it. </p>
  
  <p><strong>How can I remove 1 column from the SQLDataReader?</strong></p>
  
  <p>This column is needed in the query mainly for ordering but is used in another area on the same pageload, but I do not wish for it to be displayed in the csv file that I will be generating.</p>
  
  <p>EDIT:
  I think that I was somewhat missleading, The column that I wish to delete is used in other cases, just not this one, So just removing from the query will work but would cause me to have to run the query twice, instead of only once, and it is a larger query. </p>