title: Delete all rows in a datatable
body: <p>I need to delete all the rows in a datatable (ADO.net). I dont want to use Foreach here.</p>
  
  <p>In one single how can I delete all the rows.</p>
  
  <p>Then I need to update the datatable to database.</p>
  
  <p>Note: I have tried dataset.tables[0].rows.clear and dataset.clear but both are not working</p>
  
  <p>Also I dont want to use sql delete query.</p>
  
  <p>Post other than this if you able to provide answer.</p>