Code:
/ DotNET / DotNET / 8.0 / untmp / whidbey / REDBITS / ndp / fx / src / xsp / System / Web / UI / WebControls / FilteredDataSetHelper.cs / 2 / 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; } } } }
Link Menu

This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- RoutedUICommand.cs
- Trace.cs
- ProcessHostFactoryHelper.cs
- SelectionProcessor.cs
- ToolStripLabel.cs
- Errors.cs
- CrossContextChannel.cs
- ListView.cs
- DesignTimeDataBinding.cs
- ProcessModuleCollection.cs
- EventRouteFactory.cs
- SessionState.cs
- ArrayItemReference.cs
- webeventbuffer.cs
- SqlCommandSet.cs
- ParseHttpDate.cs
- QuaternionAnimationBase.cs
- EnumConverter.cs
- ReferentialConstraintRoleElement.cs
- RegisteredArrayDeclaration.cs
- Translator.cs
- WindowsRichEdit.cs
- Propagator.JoinPropagator.JoinPredicateVisitor.cs
- FamilyMapCollection.cs
- ContextMenuStrip.cs
- SamlSubjectStatement.cs
- NavigationService.cs
- DSACryptoServiceProvider.cs
- PriorityQueue.cs
- GridSplitter.cs
- ChooseAction.cs
- WindowsRichEdit.cs
- PhysicalAddress.cs
- DetailsViewRowCollection.cs
- PrinterResolution.cs
- WebSysDescriptionAttribute.cs
- CodeAttributeArgument.cs
- EventDrivenDesigner.cs
- CodeEventReferenceExpression.cs
- DataBindEngine.cs
- ScriptingProfileServiceSection.cs
- LogExtentCollection.cs
- nulltextcontainer.cs
- DetailsViewUpdateEventArgs.cs
- ListCardsInFileRequest.cs
- ConfigurationProviderException.cs
- SocketPermission.cs
- ProofTokenCryptoHandle.cs
- Utils.cs
- SplineQuaternionKeyFrame.cs
- Configuration.cs
- transactioncontext.cs
- TdsParserSessionPool.cs
- OleDbTransaction.cs
- ObjectNavigationPropertyMapping.cs
- TextServicesHost.cs
- Converter.cs
- EntityDataSourceColumn.cs
- CodeAccessSecurityEngine.cs
- FileDialog_Vista_Interop.cs
- SqlClientFactory.cs
- OdbcEnvironment.cs
- DetailsViewInsertedEventArgs.cs
- DecodeHelper.cs
- AppearanceEditorPart.cs
- CommandField.cs
- InstanceNotReadyException.cs
- RectangleHotSpot.cs
- XamlReader.cs
- DeleteWorkflowOwnerCommand.cs
- OleDbParameterCollection.cs
- LinkArea.cs
- MetadataArtifactLoaderResource.cs
- DataGridLinkButton.cs
- CommandExpr.cs
- BitmapEffectInput.cs
- DataGridRelationshipRow.cs
- InternalUserCancelledException.cs
- Stroke2.cs
- InvalidOperationException.cs
- EmptyTextWriter.cs
- FrameworkTextComposition.cs
- XamlToRtfWriter.cs
- ProxyHwnd.cs
- SingleTagSectionHandler.cs
- StopStoryboard.cs
- Registry.cs
- FontNamesConverter.cs
- ProfileEventArgs.cs
- __Error.cs
- DataGridViewCellEventArgs.cs
- DefaultBinder.cs
- LiteralControl.cs
- DecimalKeyFrameCollection.cs
- ItemType.cs
- Enum.cs
- ProviderSettingsCollection.cs
- CompositeFontParser.cs
- ButtonChrome.cs
- TriggerActionCollection.cs