Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / whidbey / netfxsp / ndp / fx / src / xsp / System / Web / UI / WebControls / FilteredDataSetHelper.cs / 5 / 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
- SQLMoneyStorage.cs
- WebContext.cs
- ImageMap.cs
- UrlSyndicationContent.cs
- SchemaSetCompiler.cs
- TraceSection.cs
- CodeThrowExceptionStatement.cs
- HWStack.cs
- DataGridLinkButton.cs
- followingsibling.cs
- ObjectItemCollection.cs
- DataKey.cs
- FolderBrowserDialogDesigner.cs
- OdbcTransaction.cs
- StructuredTypeEmitter.cs
- TabControl.cs
- AssemblyAttributes.cs
- ErrorTableItemStyle.cs
- ColumnReorderedEventArgs.cs
- Native.cs
- RoleManagerEventArgs.cs
- SynchronizationContext.cs
- TextBoxRenderer.cs
- ExpressionUtilities.cs
- CanonicalFontFamilyReference.cs
- TraceSource.cs
- HandlerBase.cs
- shaperfactory.cs
- sitestring.cs
- LoginCancelEventArgs.cs
- storepermission.cs
- ErrorsHelper.cs
- OciHandle.cs
- XmlSerializerObjectSerializer.cs
- NativeObjectSecurity.cs
- WebProxyScriptElement.cs
- EventRoute.cs
- PropertyValueChangedEvent.cs
- ClientData.cs
- ImageCodecInfo.cs
- RoleGroup.cs
- Error.cs
- LayoutEvent.cs
- CmsInterop.cs
- ProvidersHelper.cs
- EntityClientCacheKey.cs
- DetailsViewDeletedEventArgs.cs
- XPathChildIterator.cs
- ObjectSecurity.cs
- AssemblyBuilder.cs
- FileChangesMonitor.cs
- XmlSerializerFaultFormatter.cs
- ZoomingMessageFilter.cs
- PropertyPath.cs
- IChannel.cs
- Empty.cs
- SortedList.cs
- IIS7WorkerRequest.cs
- EditCommandColumn.cs
- PropertyItemInternal.cs
- OperationAbortedException.cs
- XmlILStorageConverter.cs
- EmptyStringExpandableObjectConverter.cs
- Oid.cs
- Evidence.cs
- WindowsAltTab.cs
- WinEventHandler.cs
- Evidence.cs
- ContainerUtilities.cs
- FileDialogPermission.cs
- QueryExtender.cs
- FastEncoderWindow.cs
- HwndAppCommandInputProvider.cs
- SplineKeyFrames.cs
- KnownColorTable.cs
- ConfigurationException.cs
- InvalidateEvent.cs
- XmlUtil.cs
- DispatcherObject.cs
- BitmapSizeOptions.cs
- XmlDataLoader.cs
- TextTreeUndoUnit.cs
- AdPostCacheSubstitution.cs
- Camera.cs
- RectConverter.cs
- DefaultEventAttribute.cs
- RegisterResponseInfo.cs
- DbProviderConfigurationHandler.cs
- _CookieModule.cs
- FrameworkRichTextComposition.cs
- ConfigUtil.cs
- XmlNavigatorStack.cs
- SchemaMerger.cs
- PreviewPrintController.cs
- IntPtr.cs
- Style.cs
- IndependentAnimationStorage.cs
- Event.cs
- ColumnMapVisitor.cs
- CheckBox.cs