title: Datatable Union using Linq
body: <p>My data table dt has columns are as below</p>
  
  <p><strong>Name, Value, key, IsMarkets, IsBudgets, IsPrograms</strong>   </p>
  
  <p>I have 3 check boxes chkbxBudgetsSearch,chkbxMarketsSearch,chkbxProgramsSearch</p>
  
  <p>I want dt  to be filtered on following condition</p>
  
  <p>if chkbxMarketsSearch.IsChecked == true 
  all rows with  IsMarkets=True should be displayed </p>
  
  <p>if chkbxBudgetsSearch.IsChecked == true 
  all rows with  IsBudgets=True should be displayed </p>
  
  <p>similarly for programs </p>
  
  <p>and if both  check boxes are clicked then<br>
  all rows with  IsMarkets=True and IsBudgets=False / IsMarkets=False and IsBudgets=True
  / IsMarkets=True and IsBudgets=True  should be displayed</p>
  
  <p>Note : its need not be only IsMarkets=True and IsBudgets=True </p>
  
  <p>Its close to union operation 
  Can anyone wrire linq for this ?</p>