Posted By

rengber on 01/31/08

Tagged

data
filter

Versions (?)

Last Edited at 01/31/08 08:01pm

Statistics

Viewed 873 times

Favorited by 0 user(s)

Related snippets

Filter Expression for a DataTable

/ Published in: C#

Pretty intuitive, might be an easier/simpler way.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

//This was the hard way.  
public static Lookup.StatusDataTable GetStatuses(bool intranetMode)
        {
            //TODO: Handle Intranet vs Internet mode.  
            LookupTableAdapters.StatusTableAdapter sta = new LookupTableAdapters.StatusTableAdapter();
            Lookup.StatusDataTable sdt = sta.GetStatusData();
            DataRow[] rows = sdt.Select("Status <> 'Unapproved' and Status <> 'Closed'");            
            Lookup.StatusDataTable retVal = new Lookup.StatusDataTable(); 
            foreach(DataRow dr in rows)
            {
                retVal.Rows.Add(dr.ItemArray); 
            }
            return retVal; 
        }
 
//Here's the easy way: 
        public static Lookup.StatusDataTable GetStatuses(bool intranetMode)
        {
            LookupTableAdapters.StatusTableAdapter sta = new LookupTableAdapters.StatusTableAdapter();
            Lookup.StatusDataTable sdt = sta.GetStatusData();
            if (!intranetMode)
            {
                sdt.DefaultView.RowFilter = "Status <> 'Unapproved' and Status <> 'Closed'"; 
            }
            return sdt; 
        }