title: Get filtered data from dataset to datatable
body: <p>How can I filter data from dataset to datatable?
  like the code-></p>
  
  <pre><code>DataRow[] dr = DS.Tables[0]
      .Select("STAGENAME='Develop' AND DEVLAPSEDAYS IS NOT NULL");        
  </code></pre>
  
  <p>How can I use datatable here?</p>
  
  <p>following code doesn`t reflect changes-></p>
  
  <pre><code>DataTable FilteredDataD = DS.Tables[0];
  if (FilteredDataD.Rows.Count &gt; 0) {
      FilteredDataD.DefaultView.RowFilter = "STAGENAME='Develop' AND DEVLAPSEDAYS IS NOT NULL";
      FilteredDataD.DefaultView.ToTable();
  }
  </code></pre>
  
  <p>Is is possible to remove a column using above filter,like "STAGENAME='Develop' AND DEVLAPSEDAYS IS NOT NULL" + FilteredDataD.column("col_name")...
  Suppose I have 5 columns display only 4,I can`t remove col_name from my query.Is there a way?</p>
  
  <p>Reply</p>