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
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- PropagatorResult.cs
- Msmq3PoisonHandler.cs
- DataGridPageChangedEventArgs.cs
- DataGridViewTextBoxEditingControl.cs
- COM2IProvidePropertyBuilderHandler.cs
- Int16Storage.cs
- OleDragDropHandler.cs
- MetabaseSettings.cs
- GestureRecognitionResult.cs
- XMLSchema.cs
- ConfigurationManagerInternalFactory.cs
- WebHostUnsafeNativeMethods.cs
- ErrorTableItemStyle.cs
- CallbackValidator.cs
- SystemEvents.cs
- MarshalByValueComponent.cs
- RequestContext.cs
- ItemContainerPattern.cs
- SolidColorBrush.cs
- SecurityTokenAttachmentMode.cs
- Brush.cs
- EnumConverter.cs
- Matrix3DValueSerializer.cs
- OfTypeExpression.cs
- ProfileSettings.cs
- SplitterEvent.cs
- MediaContextNotificationWindow.cs
- WsdlParser.cs
- Dump.cs
- DeleteHelper.cs
- EntitySetBaseCollection.cs
- ThemeConfigurationDialog.cs
- GridViewColumn.cs
- FlowLayout.cs
- EntityConnectionStringBuilder.cs
- PropertyPathConverter.cs
- ImpersonationContext.cs
- AnonymousIdentificationModule.cs
- VerificationException.cs
- OleDbConnection.cs
- CmsInterop.cs
- TaskExceptionHolder.cs
- SqlNotificationRequest.cs
- BlockingCollection.cs
- UnsafeNativeMethods.cs
- XmlUtf8RawTextWriter.cs
- TreeWalker.cs
- Image.cs
- ActivityBindForm.cs
- HttpChannelBindingToken.cs
- ValidatingReaderNodeData.cs
- HtmlUtf8RawTextWriter.cs
- StaticFileHandler.cs
- SetState.cs
- ByteAnimationBase.cs
- DataSourceExpression.cs
- StreamGeometry.cs
- SecurityElement.cs
- ClientScriptManagerWrapper.cs
- Drawing.cs
- NativeMethods.cs
- DataGridViewBindingCompleteEventArgs.cs
- CodeParameterDeclarationExpression.cs
- HtmlUtf8RawTextWriter.cs
- HttpCapabilitiesBase.cs
- PaperSource.cs
- UIElementParaClient.cs
- PreloadedPackages.cs
- SettingsBindableAttribute.cs
- Debug.cs
- cookie.cs
- SafeBitVector32.cs
- HttpCapabilitiesSectionHandler.cs
- ConfigurationStrings.cs
- FactoryGenerator.cs
- ViewGenerator.cs
- ProgressPage.cs
- CompositionDesigner.cs
- ManagedWndProcTracker.cs
- ExpandedWrapper.cs
- ExtractCollection.cs
- SystemIPInterfaceProperties.cs
- DataBoundControlHelper.cs
- GeometryConverter.cs
- OdbcReferenceCollection.cs
- TextServicesContext.cs
- NotConverter.cs
- XmlSchemaSimpleTypeList.cs
- ExpressionPrinter.cs
- MediaElement.cs
- CompositeDataBoundControl.cs
- IHttpResponseInternal.cs
- DateTimeSerializationSection.cs
- DictionaryChange.cs
- SchemaNotation.cs
- _ShellExpression.cs
- DiscoveryDocumentSerializer.cs
- ListBindingHelper.cs
- WindowsGraphicsWrapper.cs
- ParameterModifier.cs