Get Proper Filtered Results from a Data View

Ever notice how your data isn’t filtered properly even though you’ve set the Row Filter Expression correctly? For example, suppose you have this code:

DataView dv  = ds.Tables[0].DefaultView;  dv.RowFilter ="location=11";      foreach(DataRow dr in dv.Table.Rows){    Response.Write(dr[0].ToString()+"<br>");}

This will display all records.

To get the actual result, loop through the DataView itself, as shown below:

for(int j=0; j< dv.Count; j++){  Response.Write(dv[j][0].ToString()+"
"); }