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
- Token.cs
- PropertyIdentifier.cs
- ResourcePermissionBaseEntry.cs
- PngBitmapEncoder.cs
- DbgCompiler.cs
- TakeQueryOptionExpression.cs
- WindowsMenu.cs
- PenContext.cs
- WebBrowserProgressChangedEventHandler.cs
- EdmRelationshipRoleAttribute.cs
- PassportAuthentication.cs
- Convert.cs
- ListViewSortEventArgs.cs
- ShapingWorkspace.cs
- SimpleWebHandlerParser.cs
- ClientCredentialsElement.cs
- UniqueID.cs
- AppDomainAttributes.cs
- QueryStringParameter.cs
- XmlEncoding.cs
- DefaultValueTypeConverter.cs
- FontFamily.cs
- SmtpFailedRecipientsException.cs
- CodeIdentifiers.cs
- ShaderEffect.cs
- _NetworkingPerfCounters.cs
- FormsAuthenticationUserCollection.cs
- StorageBasedPackageProperties.cs
- Exceptions.cs
- SettingsPropertyValue.cs
- EpmContentDeSerializerBase.cs
- OperatingSystem.cs
- StatusBar.cs
- _DisconnectOverlappedAsyncResult.cs
- ActiveXSite.cs
- DataRowComparer.cs
- UndoEngine.cs
- WriteableOnDemandStream.cs
- ToolStripSettings.cs
- URLAttribute.cs
- IdentityManager.cs
- ListManagerBindingsCollection.cs
- DebugViewWriter.cs
- ConditionValidator.cs
- TableRow.cs
- isolationinterop.cs
- TextParaClient.cs
- HostProtectionException.cs
- TabPageDesigner.cs
- ResourceManager.cs
- DataComponentGenerator.cs
- ToggleButton.cs
- MemberPathMap.cs
- ListMarkerSourceInfo.cs
- DataGridViewCellContextMenuStripNeededEventArgs.cs
- PolicyException.cs
- ProfileBuildProvider.cs
- TabControl.cs
- ExclusiveCanonicalizationTransform.cs
- ActivityFunc.cs
- DataRecordInternal.cs
- DataConnectionHelper.cs
- XmlAtomicValue.cs
- Model3D.cs
- RenderDataDrawingContext.cs
- DateTimeFormat.cs
- ELinqQueryState.cs
- RegexWriter.cs
- UseLicense.cs
- PersonalizablePropertyEntry.cs
- DrawListViewItemEventArgs.cs
- DataGridViewToolTip.cs
- MemberBinding.cs
- MobileControlsSectionHandler.cs
- StyleXamlTreeBuilder.cs
- ValueOfAction.cs
- CodeCastExpression.cs
- SplayTreeNode.cs
- ColorConvertedBitmap.cs
- FormsAuthenticationModule.cs
- GridViewSortEventArgs.cs
- RtfToXamlReader.cs
- SchemaObjectWriter.cs
- StylusShape.cs
- TcpChannelFactory.cs
- RootProfilePropertySettingsCollection.cs
- EntityStoreSchemaGenerator.cs
- ValueChangedEventManager.cs
- PeerCollaboration.cs
- adornercollection.cs
- PtsHost.cs
- TextParagraph.cs
- ResourceLoader.cs
- CompilerInfo.cs
- TagMapCollection.cs
- SqlUdtInfo.cs
- SqlFlattener.cs
- EventOpcode.cs
- CmsUtils.cs
- CombinedHttpChannel.cs