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()+"<br>"); }

Srinath MS

Submit a Tip

Browse ".NET" Tips

Browse All Tips

0 Comments (click to add your comment)

Comment and Contribute