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
- SimpleMailWebEventProvider.cs
- UIntPtr.cs
- BreakRecordTable.cs
- UnsafeNativeMethods.cs
- AppDomainManager.cs
- ReflectionUtil.cs
- PhysicalFontFamily.cs
- ResolveInfo.cs
- VsPropertyGrid.cs
- ResourceDictionaryCollection.cs
- BindingNavigatorDesigner.cs
- UIElement3DAutomationPeer.cs
- NativeMethods.cs
- TemplateKey.cs
- BuiltInExpr.cs
- DataViewSetting.cs
- WebContext.cs
- GenerateTemporaryTargetAssembly.cs
- Expression.cs
- EntityDataSourceWrapperPropertyDescriptor.cs
- ObjectDataSourceFilteringEventArgs.cs
- SimpleRecyclingCache.cs
- FontUnitConverter.cs
- While.cs
- XmlWriterTraceListener.cs
- BitmapSourceSafeMILHandle.cs
- DetailsViewDeletedEventArgs.cs
- ObjectFullSpanRewriter.cs
- Misc.cs
- ConfigXmlComment.cs
- embossbitmapeffect.cs
- SerializationStore.cs
- TextBlockAutomationPeer.cs
- EncoderParameter.cs
- ClientRuntimeConfig.cs
- EmptyEnumerator.cs
- LogEntry.cs
- NumericUpDownAcceleration.cs
- PropertyIDSet.cs
- WebUtil.cs
- LinkConverter.cs
- DBDataPermission.cs
- PartialCachingControl.cs
- ConfigurationStrings.cs
- UITypeEditor.cs
- SystemTcpStatistics.cs
- BooleanExpr.cs
- DescendantBaseQuery.cs
- Cursors.cs
- BaseAddressElement.cs
- HtmlImageAdapter.cs
- LifetimeMonitor.cs
- base64Transforms.cs
- RelatedEnd.cs
- DesignerEventService.cs
- StrongNameMembershipCondition.cs
- RoleService.cs
- XmlSchemaSimpleContentExtension.cs
- LicenseProviderAttribute.cs
- AncillaryOps.cs
- SiteMembershipCondition.cs
- AnimationClock.cs
- ConfigurationSectionGroupCollection.cs
- DataBoundControlHelper.cs
- Int16Storage.cs
- EncryptedPackage.cs
- EntityDataSource.cs
- XomlCompilerHelpers.cs
- Error.cs
- RTLAwareMessageBox.cs
- QueueSurrogate.cs
- EncodingTable.cs
- WebPartConnectionCollection.cs
- WindowsListView.cs
- CustomValidator.cs
- BaseTemplatedMobileComponentEditor.cs
- CompilerGeneratedAttribute.cs
- RepeaterCommandEventArgs.cs
- JsonReader.cs
- XMLSchema.cs
- HtmlHead.cs
- PointValueSerializer.cs
- JournalNavigationScope.cs
- ContainerControl.cs
- StructuralType.cs
- ContentElementAutomationPeer.cs
- DocumentReference.cs
- EntityDataReader.cs
- QuarticEase.cs
- ChangeBlockUndoRecord.cs
- NeutralResourcesLanguageAttribute.cs
- ButtonStandardAdapter.cs
- Wizard.cs
- XpsImageSerializationService.cs
- HandleTable.cs
- RemoteArgument.cs
- EntityKey.cs
- WebPartDisplayModeCollection.cs
- CodeAccessPermission.cs
- WsdlHelpGeneratorElement.cs