Code:
/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / whidbey / NetFXspW7 / 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
- HandlerBase.cs
- SQLCharsStorage.cs
- CheckBoxRenderer.cs
- EntityDesignerBuildProvider.cs
- XmlQualifiedName.cs
- DataGridViewColumnTypePicker.cs
- TableParaClient.cs
- PropagatorResult.cs
- BitmapMetadataBlob.cs
- PointHitTestResult.cs
- MergeFilterQuery.cs
- Msmq.cs
- AnnotationResourceCollection.cs
- EntryIndex.cs
- SafeSecurityHandles.cs
- Parser.cs
- InheritablePropertyChangeInfo.cs
- CopyOnWriteList.cs
- RegistrySecurity.cs
- ItemList.cs
- DbParameterCollectionHelper.cs
- WebControlParameterProxy.cs
- CustomWebEventKey.cs
- NavigatingCancelEventArgs.cs
- isolationinterop.cs
- ContentTextAutomationPeer.cs
- HighContrastHelper.cs
- HtmlValidationSummaryAdapter.cs
- OleDbSchemaGuid.cs
- EventProviderWriter.cs
- TransformDescriptor.cs
- PolyQuadraticBezierSegment.cs
- WebBrowserPermission.cs
- NativeMethods.cs
- Font.cs
- FixedStringLookup.cs
- FilteredSchemaElementLookUpTable.cs
- IISUnsafeMethods.cs
- SuppressIldasmAttribute.cs
- ImageKeyConverter.cs
- MultitargetingHelpers.cs
- DataGridViewCellCollection.cs
- WebSysDefaultValueAttribute.cs
- XmlMapping.cs
- ClickablePoint.cs
- GregorianCalendarHelper.cs
- ObjectNavigationPropertyMapping.cs
- XmlAttributeOverrides.cs
- Substitution.cs
- PointLightBase.cs
- DataGridViewIntLinkedList.cs
- _SslState.cs
- AttributeEmitter.cs
- TypeListConverter.cs
- TrailingSpaceComparer.cs
- XmlElementAttribute.cs
- ClosableStream.cs
- Unit.cs
- processwaithandle.cs
- UnsafeCollabNativeMethods.cs
- PersonalizationStateInfoCollection.cs
- VariableBinder.cs
- VirtualizingPanel.cs
- BinaryObjectReader.cs
- BufferedMessageData.cs
- ControlCachePolicy.cs
- RubberbandSelector.cs
- CharUnicodeInfo.cs
- DesignTimeResourceProviderFactoryAttribute.cs
- ListViewDeletedEventArgs.cs
- BackEase.cs
- DBNull.cs
- RootBrowserWindow.cs
- MenuItemCollection.cs
- RequestTimeoutManager.cs
- SpellerError.cs
- CollectionViewGroupInternal.cs
- complextypematerializer.cs
- XmlHierarchicalEnumerable.cs
- ObjectConverter.cs
- XmlSchemaExternal.cs
- ImageSource.cs
- VisualBrush.cs
- AxDesigner.cs
- Propagator.JoinPropagator.cs
- StyleHelper.cs
- AlphabeticalEnumConverter.cs
- DataViewManager.cs
- XmlSchemaGroup.cs
- Empty.cs
- TemplateContainer.cs
- RelatedPropertyManager.cs
- UIPermission.cs
- HostingPreferredMapPath.cs
- Single.cs
- QilTernary.cs
- ColumnResizeUndoUnit.cs
- ReaderWriterLock.cs
- BindingContext.cs
- InputMethod.cs