title: How to retain datagrid ordering asc/desc by column after reload VB.NET
body: <p>I have datagrid populated from Access database every 60 seconds in timer_tick() subroutine. </p>
  
  <pre><code>Dim direction As SortOrder
  .
  .
  .
  </code></pre>
  
  <p>DataGridView1 ColumnHeaderMouseClick code :</p>
  
  <pre><code>direction = DataGridView1.SortOrder
  MsgBox(direction.ToString())
  </code></pre>
  
  <p>Now, every other click it shows descending and other half '2' , just number insted of Ascending.
  Does anyone know why that is happening or how to fix it?</p>
  
  <p>What I try to achieve is to retain sortorder after datagrid is automatically reloaded within timer tick() sub.</p>