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
- RelationshipConverter.cs
- NaturalLanguageHyphenator.cs
- XmlIgnoreAttribute.cs
- PageHandlerFactory.cs
- CheckBoxList.cs
- WindowsFormsSectionHandler.cs
- ExpressionStringBuilder.cs
- WebControlsSection.cs
- UInt32.cs
- X509CertificateChain.cs
- ShapeTypeface.cs
- HMACSHA384.cs
- SnapLine.cs
- HtmlForm.cs
- HMACSHA1.cs
- SchemaMapping.cs
- CompositeFontParser.cs
- ExtensionDataObject.cs
- Pkcs7Signer.cs
- Brush.cs
- MetafileHeaderWmf.cs
- ComponentDispatcherThread.cs
- SQLInt64.cs
- TextModifier.cs
- TabItem.cs
- HttpModuleAction.cs
- DirectoryInfo.cs
- XmlDomTextWriter.cs
- InternalBufferOverflowException.cs
- SerializationEventsCache.cs
- UIElement.cs
- SqlUDTStorage.cs
- TreeNodeCollection.cs
- TranslateTransform.cs
- EntityContainerAssociationSetEnd.cs
- UserNameSecurityToken.cs
- UniqueConstraint.cs
- DeviceSpecificDesigner.cs
- MouseCaptureWithinProperty.cs
- SqlNamer.cs
- TextBox.cs
- ColorAnimation.cs
- ConfigXmlAttribute.cs
- EntityTemplateUserControl.cs
- CodeObjectCreateExpression.cs
- ManagedFilter.cs
- EditorAttributeInfo.cs
- SchemaSetCompiler.cs
- diagnosticsswitches.cs
- ClientRoleProvider.cs
- InvalidOperationException.cs
- DynamicContractTypeBuilder.cs
- MTConfigUtil.cs
- DbProviderConfigurationHandler.cs
- FormViewUpdatedEventArgs.cs
- PopupControlService.cs
- TraceContext.cs
- SqlException.cs
- DiffuseMaterial.cs
- SqlDependency.cs
- DocumentXPathNavigator.cs
- AttributeEmitter.cs
- QilFactory.cs
- returneventsaver.cs
- AttachedPropertyBrowsableAttribute.cs
- BCryptNative.cs
- ListViewContainer.cs
- MetadataProperty.cs
- SerializationBinder.cs
- SpeechDetectedEventArgs.cs
- WebPartConnection.cs
- MethodRental.cs
- WindowsListViewSubItem.cs
- Schema.cs
- HostnameComparisonMode.cs
- FileRecordSequence.cs
- NameSpaceEvent.cs
- UnsafeNativeMethods.cs
- SmtpTransport.cs
- XmlNamespaceMappingCollection.cs
- ErrorWebPart.cs
- FieldNameLookup.cs
- Size3DConverter.cs
- FileDialog.cs
- Int16Converter.cs
- GlobalItem.cs
- FieldAccessException.cs
- SafeRightsManagementQueryHandle.cs
- OperatorExpressions.cs
- DocComment.cs
- Hashtable.cs
- AttachedAnnotationChangedEventArgs.cs
- CqlParser.cs
- SmiSettersStream.cs
- DaylightTime.cs
- OperationResponse.cs
- XmlDataSourceNodeDescriptor.cs
- EncoderReplacementFallback.cs
- DataGridCaption.cs
- WebBrowserNavigatingEventHandler.cs