Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / whidbey / NetFxQFE / ndp / fx / src / xsp / System / Web / UI / WebControls / FilteredDataSetHelper.cs / 1 / 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

This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- StyleBamlTreeBuilder.cs
- StorageInfo.cs
- SimpleLine.cs
- CallSiteBinder.cs
- App.cs
- DelegatedStream.cs
- HtmlImage.cs
- EpmCustomContentSerializer.cs
- AccessibleObject.cs
- Parser.cs
- ItemChangedEventArgs.cs
- ObjectStateEntryBaseUpdatableDataRecord.cs
- _UncName.cs
- SymbolType.cs
- NotifyInputEventArgs.cs
- PagerSettings.cs
- FlowDocumentView.cs
- BuildProvider.cs
- AdPostCacheSubstitution.cs
- ExpandedWrapper.cs
- ResourceWriter.cs
- StringExpressionSet.cs
- SafeFileMapViewHandle.cs
- ComPlusServiceLoader.cs
- Baml2006SchemaContext.cs
- XmlUnspecifiedAttribute.cs
- DocobjHost.cs
- SafeNativeMethods.cs
- Context.cs
- StrongNameIdentityPermission.cs
- GridViewRow.cs
- SystemPens.cs
- ManagementObject.cs
- DBConnection.cs
- XamlRtfConverter.cs
- SymbolTable.cs
- SqlDataSourceStatusEventArgs.cs
- GridViewPageEventArgs.cs
- MonthCalendar.cs
- DataSourceXmlElementAttribute.cs
- SynchronizingStream.cs
- PassportAuthenticationEventArgs.cs
- MatrixKeyFrameCollection.cs
- Tuple.cs
- InheritanceRules.cs
- MessageSecurityOverHttpElement.cs
- TextBoxRenderer.cs
- MenuItemBindingCollection.cs
- UnmanagedHandle.cs
- Debugger.cs
- HttpModulesSection.cs
- SQLUtility.cs
- WebReferencesBuildProvider.cs
- MailMessage.cs
- ZipIOExtraFieldElement.cs
- ValidationManager.cs
- CqlIdentifiers.cs
- InputEventArgs.cs
- Win32.cs
- DictionarySectionHandler.cs
- ButtonDesigner.cs
- SqlDataAdapter.cs
- SQLInt16.cs
- FocusManager.cs
- mediaeventargs.cs
- ConnectionStringsExpressionBuilder.cs
- Type.cs
- DiscreteKeyFrames.cs
- DetailsViewPagerRow.cs
- ConnectionManagementElementCollection.cs
- ContainerFilterService.cs
- TagPrefixCollection.cs
- EntityDataSourceViewSchema.cs
- FilteredAttributeCollection.cs
- HttpContext.cs
- CodeMemberMethod.cs
- DependencyPropertyKind.cs
- ViewStateModeByIdAttribute.cs
- MouseCaptureWithinProperty.cs
- TransformedBitmap.cs
- ToolStripDesignerAvailabilityAttribute.cs
- InlineUIContainer.cs
- DeploymentExceptionMapper.cs
- Message.cs
- ErrorsHelper.cs
- ParserContext.cs
- UIntPtr.cs
- ClassicBorderDecorator.cs
- FrameworkPropertyMetadata.cs
- DoubleMinMaxAggregationOperator.cs
- AnnotationComponentManager.cs
- IProvider.cs
- XmlWriter.cs
- EventLogEntry.cs
- ConnectionConsumerAttribute.cs
- FileDialog_Vista.cs
- InternalConfigSettingsFactory.cs
- X509SecurityTokenAuthenticator.cs
- EventLogPermissionAttribute.cs
- WindowsPrincipal.cs