title: String to mmm-yy format of time in C#
body: <p>I need to perform some date operations in ASP.net using C#. </p>
  
  <ol>
  <li><p>The date i would enter should be of format 'Jul-05' (mmm-yy Format and type-<strong>string</strong>)... 
  how can i check with this????
  Or how can i validate this with whatever user is entering as a string???</p></li>
  <li><p>After validating that, i need to compare tht with a value in Database(say a column name <em>buy_period</em> which has a value (say) 04/31/2007).</p></li>
  </ol>
  
  <p>How can i write a Query for comparing both?? (as both dates would be of different formats)</p>
  
  <p>Can u pls help me in this ???</p>