Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / whidbey / netfxsp / ndp / fx / src / xsp / System / Web / UI / WebControls / FilteredDataSetHelper.cs / 5 / 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
- DataServiceProviderWrapper.cs
- CheckBox.cs
- DataControlFieldTypeEditor.cs
- RunClient.cs
- BufferedGraphicsManager.cs
- EntityDataSourceWizardForm.cs
- TypeConstant.cs
- LayoutTableCell.cs
- PageVisual.cs
- ConnectionAcceptor.cs
- ClientConvert.cs
- AnnotationMap.cs
- FontFamilyValueSerializer.cs
- Privilege.cs
- SynchronizedDispatch.cs
- SelectingProviderEventArgs.cs
- Context.cs
- SafeReadContext.cs
- SystemKeyConverter.cs
- WebPartExportVerb.cs
- XamlSerializerUtil.cs
- HtmlTernaryTree.cs
- MissingMethodException.cs
- HwndSubclass.cs
- Encoding.cs
- CompModSwitches.cs
- GraphicsContainer.cs
- AutomationPatternInfo.cs
- SchemaTypeEmitter.cs
- TimelineGroup.cs
- RelationshipType.cs
- DataGridViewHitTestInfo.cs
- EmbeddedMailObjectsCollection.cs
- ConfigurationElementProperty.cs
- JoinSymbol.cs
- ConfigurationLockCollection.cs
- DbMetaDataFactory.cs
- SqlBulkCopy.cs
- XmlTextEncoder.cs
- QilCloneVisitor.cs
- PointConverter.cs
- SqlConnectionManager.cs
- OutputCacheSettingsSection.cs
- SchemaMerger.cs
- TextPenaltyModule.cs
- sitestring.cs
- ControlAdapter.cs
- DLinqAssociationProvider.cs
- CredentialCache.cs
- CodeDirectoryCompiler.cs
- Crypto.cs
- EpmAttributeNameBuilder.cs
- MethodMessage.cs
- DataShape.cs
- UserValidatedEventArgs.cs
- TriggerCollection.cs
- ContentHostHelper.cs
- ETagAttribute.cs
- PlainXmlSerializer.cs
- Substitution.cs
- DBCSCodePageEncoding.cs
- NumberFunctions.cs
- SelectionEditor.cs
- Flattener.cs
- MethodExpr.cs
- MultiView.cs
- Int32Converter.cs
- MultipartIdentifier.cs
- SoapElementAttribute.cs
- OleCmdHelper.cs
- Compilation.cs
- PreviewPageInfo.cs
- DtdParser.cs
- PrinterResolution.cs
- StyleXamlTreeBuilder.cs
- XmlCharType.cs
- ModuleConfigurationInfo.cs
- TextBoxBase.cs
- templategroup.cs
- XPathChildIterator.cs
- DataGridViewAutoSizeModeEventArgs.cs
- WebPartConnection.cs
- ExpressionPrinter.cs
- InputMethodStateChangeEventArgs.cs
- UiaCoreProviderApi.cs
- DataTablePropertyDescriptor.cs
- SettingsSavedEventArgs.cs
- GridViewDeletedEventArgs.cs
- HostProtectionPermission.cs
- DataViewManagerListItemTypeDescriptor.cs
- URLMembershipCondition.cs
- Label.cs
- PrintEvent.cs
- XmlSerializerVersionAttribute.cs
- SqlRemoveConstantOrderBy.cs
- XmlIlTypeHelper.cs
- ResourcePermissionBase.cs
- ICspAsymmetricAlgorithm.cs
- ListView.cs
- TrustLevelCollection.cs