title: Sorting correctly data on DataSet Objet
body: <p>using Windows forms with VB in Visual studio I have the next problem</p>
  <p>when I initialize my object DataSet I got a different sort between tables</p>
  <p><a href="https://i.stack.imgur.com/jC9Xh.png" rel="nofollow noreferrer">Tables</a></p>
  <p>I Have the next code:</p>
  <pre><code>oda = New OleDbDataAdapter(&quot;Select *From AccionesDeCorreccion&quot;, cadena)
  ods.Tables.Add(&quot;AccionesDeCorreccion&quot;)
  oda.Fill(ods.Tables(&quot;AccionesDeCorreccion&quot;))
  </code></pre>
  <p>I try with the method sort in the next line</p>
  <pre><code>ods.Tables(&quot;AccionesDeCorreccion&quot;).DefaultView.Sort = &quot;ID_ACCIONES_CORRECCION ASC&quot;
  </code></pre>
  <p>but the table in my DataSet object doesn't change.</p>
  <p>How can I sort the table on my DataSet in acendent order to have the same order of my DB in Access?</p>