title: How to put two condition in lambda expression
body: <p>I have two Repeater Control</p>
  
  <pre><code>var list = from i in DA.obm_view_studentLists where i.FranchiseID == FranchiseID &amp;&amp; i.ExamDate == DateTime.Parse(this.pallavi.DropDownSelectedValue) select i;
  </code></pre>
  
  <p>I want to get result in 1 go from database.</p>
  
  <pre><code>this._approvedStudentList.DataSource = list.Select(e =&gt; e.ApprovedByOBM == true);
  
  this._pendingStudentList.DataSource = list.Select(e =&gt; e.ApprovedByOBM == false);
  </code></pre>
  
  <p>I have a Label Field (UnPaidTotal) in <strong>pendingStudentList</strong> Repeater where I want to display Total Fee Pending</p>
  
  <p>I tried but fail</p>
  
  <pre><code>UnPaidTotal = string.Format("{0:c}", list.Select(e =&gt; e.ApprovedByOBM == true).Sum(j =&gt; j.CourseFee));
  </code></pre>