title: DataView Update itself to the new rowfilter
body: <p>I am trying to retain some rows in dataview for some operations to perform after I get the filtered rows, but the issue is , every time the code runs, the dataview is updated to the filter last applied. Here is the code snippest.</p>
  
  <pre><code>If dsEmp.Tables.Count &gt; 0 Then
      dvEmp = dsEmp.Tables(0).DefaultView
      dvEmp.RowFilter = "IDENTIFICATION_CODE = '" &amp; IDENTIFICATION_CODE &amp; "' and EMPLOYEE_DESC =  'Employment1'"
      Dim dv1 As DataView = dvEmp
      dvEmp.RowFilter = ""
      If dsEmp.Tables(0).Rows.Count &gt; 1 Then
          dvEmp2 = New DataView
          dvEmp2 = dsEmp.Tables(0).DefaultView
          dvEmp2.RowFilter = "IDENTIFICATION_CODE = '" &amp; IDENTIFICATION_CODE &amp; "' and EMPLOYEE_DESC =  'Employment2'"
          Dim dv2 As DataView = dvEmp2
          dvEmp2.RowFilter = ""
      End If
      If dsEmp.Tables(0).Rows.Count &gt; 2 Then
          dvEmpPrevious = New DataView
          dvEmpPrevious = dsEmp.Tables(0).DefaultView
          dvEmpPrevious.RowFilter = "IDENTIFICATION_CODE = '" &amp; IDENTIFICATION_CODE &amp; "' and EMPLOYEE_DESC =  'Employment3'"
          Dim dv3 As DataView = dvEmpPrevious
          dvEmpPrevious.RowFilter = ""
      End If
  End If
  </code></pre>
  
  <p>but when I check the value of dv1, after second filter, it has the different values in it.</p>
  
  <p>Could any one give some solution.
  Thanks</p>