Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / whidbey / NetFxQFE / 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
- SigningCredentials.cs
- ScriptHandlerFactory.cs
- PolicyChain.cs
- SurrogateSelector.cs
- WriteFileContext.cs
- RelationshipWrapper.cs
- RequestCachingSection.cs
- DiscreteKeyFrames.cs
- HttpCapabilitiesSectionHandler.cs
- OleDbException.cs
- SelectionItemPattern.cs
- NamespaceEmitter.cs
- HuffCodec.cs
- FormClosingEvent.cs
- TextEncodedRawTextWriter.cs
- ItemChangedEventArgs.cs
- DataObjectPastingEventArgs.cs
- PageThemeParser.cs
- CFGGrammar.cs
- Attributes.cs
- PreservationFileWriter.cs
- TrackingMemoryStream.cs
- dsa.cs
- TemplateBindingExpression.cs
- WebControlsSection.cs
- ParsedRoute.cs
- OdbcCommand.cs
- SQLChars.cs
- InvokeGenerator.cs
- SrgsSemanticInterpretationTag.cs
- TextSelectionHelper.cs
- SqlDataSourceConfigureFilterForm.cs
- EventLogSession.cs
- SchemaTypeEmitter.cs
- IPCCacheManager.cs
- QilVisitor.cs
- TemplateControl.cs
- GroupQuery.cs
- WorkflowOperationContext.cs
- SystemResourceKey.cs
- SqlWebEventProvider.cs
- RtType.cs
- ObjectListShowCommandsEventArgs.cs
- XPathNodeList.cs
- ISSmlParser.cs
- TableHeaderCell.cs
- MessageBox.cs
- IDQuery.cs
- GeneralTransform3DGroup.cs
- InheritablePropertyChangeInfo.cs
- DbDeleteCommandTree.cs
- SimpleWebHandlerParser.cs
- RegisteredScript.cs
- WindowsTitleBar.cs
- TreeViewEvent.cs
- HttpListenerTimeoutManager.cs
- SessionParameter.cs
- TextBoxLine.cs
- AbstractExpressions.cs
- DataGridDefaultColumnWidthTypeConverter.cs
- XamlTypeMapper.cs
- BinaryObjectInfo.cs
- UInt16.cs
- ReadOnlyAttribute.cs
- StrokeDescriptor.cs
- SpellCheck.cs
- AutomationIdentifier.cs
- AbandonedMutexException.cs
- SetStateDesigner.cs
- DoWorkEventArgs.cs
- UserMapPath.cs
- TheQuery.cs
- rsa.cs
- SizeConverter.cs
- DocumentScope.cs
- ConcatQueryOperator.cs
- BaseDataListDesigner.cs
- SiteMapDataSourceDesigner.cs
- ResourceDictionaryCollection.cs
- StaticFileHandler.cs
- FileRecordSequenceCompletedAsyncResult.cs
- SqlProviderUtilities.cs
- mediaclock.cs
- Missing.cs
- CellParagraph.cs
- LiteralControl.cs
- ForeignKeyConstraint.cs
- streamingZipPartStream.cs
- TextFormatter.cs
- AnchorEditor.cs
- ping.cs
- MetadataArtifactLoaderFile.cs
- WebServiceFault.cs
- ControlDesignerState.cs
- X509Utils.cs
- DecimalKeyFrameCollection.cs
- CheckBoxList.cs
- ErrorActivity.cs
- Memoizer.cs
- PipeSecurity.cs