title: DataTable column position is different than result set from db
body: <p>I am getting my <code>ResultSet</code> (using <code>stored procedure</code>) in <code>DataTable</code> but strange thing is that <code>column</code> position get changed in <code>DataTable</code> then what is returned from <code>db</code>. Please look following images:
  First image is result in <code>SSMS SQL query</code> returned, which is correct.
  <img src="https://i.stack.imgur.com/JM1tD.png" alt="enter image description here"></p>
  
  <p>Second image is <code>DataTable</code> in code. How come the last tow columns change their position:
  <img src="https://i.stack.imgur.com/gPTaA.png" alt="enter image description here"></p>
  
  <p>Last two columns are being generated using <code>pivot/unpivot</code>. See this fiddle for more understanding <a href="http://www.sqlfiddle.com/#!3/8e685/46" rel="nofollow noreferrer">query fiddle</a></p>
  
  <p>Regards,</p>