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
- StaticFileHandler.cs
- EntityConnectionStringBuilderItem.cs
- XmlSchemaSimpleTypeUnion.cs
- smtppermission.cs
- UpdateProgress.cs
- SmiEventSink.cs
- CallbackHandler.cs
- input.cs
- ColorBlend.cs
- SQLStringStorage.cs
- AxisAngleRotation3D.cs
- dtdvalidator.cs
- NativeCppClassAttribute.cs
- XmlSchemaException.cs
- SchemaNotation.cs
- ToolStripProfessionalLowResolutionRenderer.cs
- MethodBody.cs
- BasicExpressionVisitor.cs
- HitTestWithPointDrawingContextWalker.cs
- MimeObjectFactory.cs
- HttpModuleActionCollection.cs
- BitArray.cs
- IdnElement.cs
- XmlTextReaderImplHelpers.cs
- XmlNamespaceDeclarationsAttribute.cs
- SrgsGrammar.cs
- SystemWebCachingSectionGroup.cs
- ImplicitInputBrush.cs
- DataSourceSelectArguments.cs
- MeasureItemEvent.cs
- Rule.cs
- ClientBuildManager.cs
- SqlDependencyListener.cs
- XmlElementAttribute.cs
- CompensationToken.cs
- Rect3DConverter.cs
- TextBoxRenderer.cs
- DataGridViewCellEventArgs.cs
- InfoCardKeyedHashAlgorithm.cs
- basecomparevalidator.cs
- StatusBarPanel.cs
- FramingDecoders.cs
- AlternateView.cs
- Activator.cs
- ComponentCollection.cs
- SamlAuthorizationDecisionClaimResource.cs
- MLangCodePageEncoding.cs
- HandlerBase.cs
- MexHttpBindingCollectionElement.cs
- ListViewSortEventArgs.cs
- DataGridViewCellStyle.cs
- securestring.cs
- PageParser.cs
- QueryMatcher.cs
- Privilege.cs
- GestureRecognizer.cs
- FloatUtil.cs
- ToolboxItemSnapLineBehavior.cs
- ClonableStack.cs
- SBCSCodePageEncoding.cs
- EventPropertyMap.cs
- SizeAnimationClockResource.cs
- ListComponentEditorPage.cs
- _ListenerRequestStream.cs
- DocumentScope.cs
- ColumnCollection.cs
- IImplicitResourceProvider.cs
- MultipartIdentifier.cs
- XomlCompilerResults.cs
- ping.cs
- AliasExpr.cs
- SiteMapSection.cs
- EntityTypeEmitter.cs
- ProviderUtil.cs
- GeometryHitTestResult.cs
- StatusBar.cs
- BaseComponentEditor.cs
- ApplicationHost.cs
- ProgressBar.cs
- XPathNode.cs
- WindowsScrollBarBits.cs
- MachineKeySection.cs
- ObjectDataSourceEventArgs.cs
- StrongNamePublicKeyBlob.cs
- SecurityTokenResolver.cs
- LoginStatusDesigner.cs
- Schema.cs
- JulianCalendar.cs
- UIAgentMonitor.cs
- PrintPreviewControl.cs
- ReaderWriterLockWrapper.cs
- ComPlusThreadInitializer.cs
- SQLMoneyStorage.cs
- FullTextLine.cs
- VisualStyleTypesAndProperties.cs
- GridViewCommandEventArgs.cs
- TimeEnumHelper.cs
- InstanceData.cs
- CorruptingExceptionCommon.cs
- NullableDecimalAverageAggregationOperator.cs