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
- _AutoWebProxyScriptHelper.cs
- SqlBulkCopyColumnMappingCollection.cs
- StreamWriter.cs
- SubstitutionList.cs
- ProfileBuildProvider.cs
- HttpAsyncResult.cs
- CqlBlock.cs
- ParserHooks.cs
- HttpResponseInternalWrapper.cs
- ICollection.cs
- SiteMap.cs
- Debug.cs
- EastAsianLunisolarCalendar.cs
- XamlTemplateSerializer.cs
- Point3DCollectionConverter.cs
- Accessible.cs
- MouseGesture.cs
- StrokeCollection2.cs
- Int64.cs
- OdbcError.cs
- SerializerProvider.cs
- ExceptionUtil.cs
- ChangesetResponse.cs
- ManipulationStartedEventArgs.cs
- DataGridParentRows.cs
- WebPartConnectionsEventArgs.cs
- SmiContext.cs
- ValueChangedEventManager.cs
- ContainerActivationHelper.cs
- ControlCollection.cs
- RegistryConfigurationProvider.cs
- Thread.cs
- WindowShowOrOpenTracker.cs
- Error.cs
- BitmapMetadata.cs
- EdmType.cs
- Debugger.cs
- DataSourceListEditor.cs
- followingsibling.cs
- Size3DValueSerializer.cs
- JavaScriptSerializer.cs
- NativeMethods.cs
- Decoder.cs
- QueryContinueDragEventArgs.cs
- TextParentUndoUnit.cs
- ProcessManager.cs
- ConfigsHelper.cs
- XPathPatternBuilder.cs
- TextEmbeddedObject.cs
- BinaryFormatter.cs
- TextElementEditingBehaviorAttribute.cs
- DataReceivedEventArgs.cs
- TcpClientChannel.cs
- CreateDataSourceDialog.cs
- SqlClientMetaDataCollectionNames.cs
- _SslSessionsCache.cs
- FontDifferentiator.cs
- DataShape.cs
- URLBuilder.cs
- AvTraceDetails.cs
- UserCancellationException.cs
- TextEndOfLine.cs
- XmlDictionaryWriter.cs
- ZoneLinkButton.cs
- UnsafeNativeMethods.cs
- NetworkStream.cs
- StateRuntime.cs
- UIElement3DAutomationPeer.cs
- SerialPort.cs
- AssertUtility.cs
- WindowsImpersonationContext.cs
- ArgumentException.cs
- WebConfigurationHostFileChange.cs
- SafeTimerHandle.cs
- RSAProtectedConfigurationProvider.cs
- DesignTimeTemplateParser.cs
- SystemWebCachingSectionGroup.cs
- PropertyNames.cs
- VScrollBar.cs
- Comparer.cs
- ContractTypeNameElement.cs
- OleDbEnumerator.cs
- PolicyValidationException.cs
- SizeValueSerializer.cs
- XmlSchemaObjectTable.cs
- EventProperty.cs
- XslTransformFileEditor.cs
- EnumMemberAttribute.cs
- ContextDataSource.cs
- RouteItem.cs
- ValidationSummaryDesigner.cs
- DocumentPaginator.cs
- ServiceBusyException.cs
- ADConnectionHelper.cs
- XpsSerializationException.cs
- QilReference.cs
- FixedDocument.cs
- PermissionListSet.cs
- QuaternionIndependentAnimationStorage.cs
- ObjectSelectorEditor.cs