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
- DataBindingHandlerAttribute.cs
- ImageInfo.cs
- DataSourceBooleanViewSchemaConverter.cs
- SwitchExpression.cs
- SafeProcessHandle.cs
- ServiceDocument.cs
- DynamicHyperLink.cs
- LayoutInformation.cs
- WebPartZoneDesigner.cs
- RequiredAttributeAttribute.cs
- ScriptReferenceEventArgs.cs
- CompilationAssemblyInstallComponent.cs
- DecoderFallbackWithFailureFlag.cs
- InstancePersistenceContext.cs
- ImageFormat.cs
- ObjectDataSourceStatusEventArgs.cs
- RijndaelManaged.cs
- Viewport2DVisual3D.cs
- MemberHolder.cs
- DataGridViewCellPaintingEventArgs.cs
- TransactionTraceIdentifier.cs
- Context.cs
- MouseOverProperty.cs
- DependencyObjectProvider.cs
- StrokeNodeData.cs
- ScopelessEnumAttribute.cs
- TemplateGroupCollection.cs
- DependencyPropertyChangedEventArgs.cs
- LocalizationParserHooks.cs
- SEHException.cs
- MultiPageTextView.cs
- PersonalizableAttribute.cs
- AutomationElement.cs
- PrintSchema.cs
- ExceptionHandler.cs
- RenamedEventArgs.cs
- RayMeshGeometry3DHitTestResult.cs
- FunctionQuery.cs
- XmlCountingReader.cs
- Preprocessor.cs
- DocumentXmlWriter.cs
- counter.cs
- WebBrowsableAttribute.cs
- ResourceReferenceKeyNotFoundException.cs
- LogReserveAndAppendState.cs
- ProcessHostServerConfig.cs
- MimeMapping.cs
- MsmqIntegrationBindingCollectionElement.cs
- RSACryptoServiceProvider.cs
- CaseStatementProjectedSlot.cs
- Int32Storage.cs
- ComponentGuaranteesAttribute.cs
- SolidColorBrush.cs
- GZipUtils.cs
- _ListenerResponseStream.cs
- XmlRawWriterWrapper.cs
- ToolTipAutomationPeer.cs
- ObjectDataSourceMethodEventArgs.cs
- Transform3DGroup.cs
- PrinterSettings.cs
- WorkflowDesignerColors.cs
- WebBrowserProgressChangedEventHandler.cs
- CompiledRegexRunner.cs
- Transform3DGroup.cs
- OverloadGroupAttribute.cs
- XamlSerializer.cs
- UserPreferenceChangingEventArgs.cs
- DataGridViewRowConverter.cs
- TextOptions.cs
- BinHexEncoder.cs
- SizeAnimationClockResource.cs
- RootBuilder.cs
- WebServiceFaultDesigner.cs
- ISessionStateStore.cs
- ResourceDisplayNameAttribute.cs
- mediaeventshelper.cs
- FieldBuilder.cs
- DoubleCollectionConverter.cs
- NonVisualControlAttribute.cs
- DataReceivedEventArgs.cs
- CheckPair.cs
- SafeSecurityHandles.cs
- DataGridViewAdvancedBorderStyle.cs
- ReadOnlyHierarchicalDataSourceView.cs
- XmlChildNodes.cs
- InvalidOleVariantTypeException.cs
- EmissiveMaterial.cs
- ValidationSummary.cs
- CodeDomSerializerException.cs
- SamlAuthorityBinding.cs
- ActivityCodeDomReferenceService.cs
- ScopedKnownTypes.cs
- AllMembershipCondition.cs
- TreeIterators.cs
- NavigationPropertyAccessor.cs
- ZipIOLocalFileHeader.cs
- Scheduler.cs
- EffectiveValueEntry.cs
- XmlLanguage.cs
- DataConnectionHelper.cs