Code:
/ DotNET / DotNET / 8.0 / untmp / whidbey / REDBITS / ndp / fx / src / xsp / System / Web / UI / WebControls / FilteredDataSetHelper.cs / 2 / 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; } } } }
Link Menu

This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- CodeNamespaceImport.cs
- StylusPoint.cs
- AlignmentYValidation.cs
- TcpTransportElement.cs
- CompiledQuery.cs
- DynamicQueryStringParameter.cs
- ReadOnlyDictionary.cs
- WorkflowLayouts.cs
- SQLInt16Storage.cs
- RegistryKey.cs
- PropertyStore.cs
- AbstractDataSvcMapFileLoader.cs
- HttpListenerException.cs
- Color.cs
- ComPersistableTypeElementCollection.cs
- HttpCacheVaryByContentEncodings.cs
- TextTreeTextBlock.cs
- CapabilitiesUse.cs
- ApplicationSecurityInfo.cs
- NativeRecognizer.cs
- ContentType.cs
- OdbcEnvironmentHandle.cs
- DesignBindingValueUIHandler.cs
- TrackingDataItem.cs
- EditorZoneAutoFormat.cs
- SqlTriggerAttribute.cs
- Form.cs
- MessageQueueAccessControlEntry.cs
- TextBlock.cs
- StrokeNodeData.cs
- DefinitionBase.cs
- SrgsElementList.cs
- ScalarOps.cs
- ProfessionalColorTable.cs
- TemplateBuilder.cs
- XpsSerializationException.cs
- DecoderFallback.cs
- SByte.cs
- ImageAnimator.cs
- HttpResponseInternalWrapper.cs
- ThemeDirectoryCompiler.cs
- PropertyCondition.cs
- XmlMembersMapping.cs
- CodeDesigner.cs
- UserControlBuildProvider.cs
- GenericWebPart.cs
- BridgeDataRecord.cs
- MainMenu.cs
- GridLength.cs
- SectionInformation.cs
- LingerOption.cs
- PtsHelper.cs
- RightsManagementPermission.cs
- TextEncodedRawTextWriter.cs
- DataObjectAttribute.cs
- TextPattern.cs
- CompositeActivityTypeDescriptorProvider.cs
- FileDetails.cs
- HtmlUtf8RawTextWriter.cs
- AuthorizationRule.cs
- CommonObjectSecurity.cs
- ProfileEventArgs.cs
- BuilderPropertyEntry.cs
- WindowsListViewSubItem.cs
- PageCanvasSize.cs
- SqlSelectClauseBuilder.cs
- CompiledQuery.cs
- GeometryHitTestResult.cs
- WindowsSpinner.cs
- ShutDownListener.cs
- ComboBox.cs
- DoubleAnimation.cs
- FunctionGenerator.cs
- NativeMethods.cs
- QuaternionRotation3D.cs
- SemanticResolver.cs
- ArithmeticLiteral.cs
- documentsequencetextview.cs
- BrushProxy.cs
- ListViewDesigner.cs
- XamlTemplateSerializer.cs
- RuntimeIdentifierPropertyAttribute.cs
- UserControl.cs
- ValidationErrorCollection.cs
- EdmToObjectNamespaceMap.cs
- LinqDataSourceStatusEventArgs.cs
- LayoutEditorPart.cs
- MetadataItemCollectionFactory.cs
- ToolConsole.cs
- ClipboardProcessor.cs
- SystemWebSectionGroup.cs
- NavigationPropertySingletonExpression.cs
- AlternateView.cs
- DataObjectMethodAttribute.cs
- XmlHelper.cs
- RSAPKCS1KeyExchangeFormatter.cs
- SmtpReplyReaderFactory.cs
- HttpPostProtocolReflector.cs
- XmlSchemaObjectCollection.cs
- BaseServiceProvider.cs