Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: .NET
Expertise: Intermediate
Mar 31, 2008

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
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap