title: How to update the particular column values of gridview on specific dates using vb.net?
body: <p>I have column in database</p>
  
  <pre><code>ID    From        To             s1from          s2to           s2price         fare
  
  1     Delhi       Manali         17-Dec-2010     19-Dec-2010    $900            $600  
  2     USA         Canada         18-Dec-2010     20-Dec-2010    $500            $800
  3     Newyork     salinas        19-Dec-2010     22-Dec-2010    $760            $1000
  </code></pre>
  
  <p>I want when any user search For: Delhi to Manali on between 17-Dec-2010  to 19-Dec-2010 then the price would be  automatically changes to $900 in gridview else the default price wold be displayed in fare is $600 if he search for DelHi to Manali after 19-Dec-2010.</p>
  
  <p>I m confused how to implement this logic ... using vb.net ... </p>