FilteredDataSetHelper.cs source code in C# .NET

Source code for the .NET framework in C#

                        
Code:

                         / 4.0 / 4.0 / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / xsp / System / Web / UI / WebControls / FilteredDataSetHelper.cs / 1305376 / FilteredDataSetHelper.cs
                        

                        
                            //------------------------------------------------------------------------------ 
// 
//     Copyright (c) Microsoft Corporation.  All rights reserved.
// 
//----------------------------------------------------------------------------- 

namespace System.Web.UI.WebControls { 
 
    using System;
    using System.Collections; 
    using System.ComponentModel;
    using System.Data;
    using System.Globalization;
    using System.Web.Util; 

    ///  
    /// Helper class for SqlDataSource and ObjectDataSource. 
    /// 
    internal static class FilteredDataSetHelper { 

        public static DataView CreateFilteredDataView(DataTable table, string sortExpression, string filterExpression, IDictionary filterParameters) {
            Debug.Assert(table != null, "Did not expect null table");
            Debug.Assert(sortExpression != null, "Did not expect null sort expression"); 
            Debug.Assert(filterExpression != null, "Did not expect null filter expression");
 
            DataView dv = new DataView(table); 
            // Set sort expression
            if (!String.IsNullOrEmpty(sortExpression)) { 
                dv.Sort = sortExpression;
            }

            // Set filter expression 
            if (!String.IsNullOrEmpty(filterExpression)) {
                bool hasNulls = false; 
                Debug.Assert(filterParameters != null, "Did not expect null filter parameters when a filter expression was set"); 
                object[] values = new object[filterParameters.Count];
                int index = 0; 
                foreach (DictionaryEntry de in filterParameters) {
                    if (de.Value == null) {
                        hasNulls = true;
                        break; 
                    }
                    values[index] = de.Value; 
                    index++; 
                }
                filterExpression = String.Format(CultureInfo.InvariantCulture, filterExpression, values); 
                // Filter expression should only be applied if there were no null parameters
                if (!hasNulls) {
                    dv.RowFilter = filterExpression;
                } 
            }
 
            return dv; 
        }
 
        public static DataTable GetDataTable(Control owner, object dataObject) {
            DataSet dataSet = dataObject as DataSet;
            if (dataSet != null) {
                if (dataSet.Tables.Count == 0) { 
                    throw new InvalidOperationException(SR.GetString(SR.FilteredDataSetHelper_DataSetHasNoTables, owner.ID));
                } 
                return dataSet.Tables[0]; 
            }
            else { 
                return dataObject as DataTable;
            }
        }
    } 
}
 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//------------------------------------------------------------------------------ 
// 
//     Copyright (c) Microsoft Corporation.  All rights reserved.
// 
//----------------------------------------------------------------------------- 

namespace System.Web.UI.WebControls { 
 
    using System;
    using System.Collections; 
    using System.ComponentModel;
    using System.Data;
    using System.Globalization;
    using System.Web.Util; 

    ///  
    /// Helper class for SqlDataSource and ObjectDataSource. 
    /// 
    internal static class FilteredDataSetHelper { 

        public static DataView CreateFilteredDataView(DataTable table, string sortExpression, string filterExpression, IDictionary filterParameters) {
            Debug.Assert(table != null, "Did not expect null table");
            Debug.Assert(sortExpression != null, "Did not expect null sort expression"); 
            Debug.Assert(filterExpression != null, "Did not expect null filter expression");
 
            DataView dv = new DataView(table); 
            // Set sort expression
            if (!String.IsNullOrEmpty(sortExpression)) { 
                dv.Sort = sortExpression;
            }

            // Set filter expression 
            if (!String.IsNullOrEmpty(filterExpression)) {
                bool hasNulls = false; 
                Debug.Assert(filterParameters != null, "Did not expect null filter parameters when a filter expression was set"); 
                object[] values = new object[filterParameters.Count];
                int index = 0; 
                foreach (DictionaryEntry de in filterParameters) {
                    if (de.Value == null) {
                        hasNulls = true;
                        break; 
                    }
                    values[index] = de.Value; 
                    index++; 
                }
                filterExpression = String.Format(CultureInfo.InvariantCulture, filterExpression, values); 
                // Filter expression should only be applied if there were no null parameters
                if (!hasNulls) {
                    dv.RowFilter = filterExpression;
                } 
            }
 
            return dv; 
        }
 
        public static DataTable GetDataTable(Control owner, object dataObject) {
            DataSet dataSet = dataObject as DataSet;
            if (dataSet != null) {
                if (dataSet.Tables.Count == 0) { 
                    throw new InvalidOperationException(SR.GetString(SR.FilteredDataSetHelper_DataSetHasNoTables, owner.ID));
                } 
                return dataSet.Tables[0]; 
            }
            else { 
                return dataObject as DataTable;
            }
        }
    } 
}
 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.

Link Menu

Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
This book is available now!
Buy at Amazon US or
Buy at Amazon UK