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
- WebPartCollection.cs
- CodePageEncoding.cs
- Console.cs
- MarginsConverter.cs
- PriorityQueue.cs
- XPathNodeIterator.cs
- cookiecollection.cs
- RayHitTestParameters.cs
- CustomBindingCollectionElement.cs
- ToolStripOverflowButton.cs
- ScrollBar.cs
- TabControlEvent.cs
- ReadOnlyHierarchicalDataSourceView.cs
- FileNotFoundException.cs
- ToolStripTextBox.cs
- AssemblyAttributesGoHere.cs
- TemplateColumn.cs
- AmbientLight.cs
- XmlChildNodes.cs
- LogicalExpr.cs
- ProxySimple.cs
- StatusInfoItem.cs
- SqlMethodCallConverter.cs
- BitVector32.cs
- NgenServicingAttributes.cs
- PeerCollaborationPermission.cs
- ExpressionLexer.cs
- PointCollectionValueSerializer.cs
- QuaternionKeyFrameCollection.cs
- EventSinkActivityDesigner.cs
- HtmlInputCheckBox.cs
- LinkedResourceCollection.cs
- WindowsPrincipal.cs
- _OverlappedAsyncResult.cs
- CodeTypeParameterCollection.cs
- ExceptionUtil.cs
- DocumentSchemaValidator.cs
- ComAdminWrapper.cs
- LinkUtilities.cs
- safelinkcollection.cs
- InkCanvasAutomationPeer.cs
- TemplateBuilder.cs
- IItemContainerGenerator.cs
- ActionItem.cs
- CodeTypeMember.cs
- StateMachineDesignerPaint.cs
- SqlWriter.cs
- SqlParameterizer.cs
- XmlSerializationWriter.cs
- DBSchemaRow.cs
- HtmlTableCellCollection.cs
- InputChannelBinder.cs
- SplineKeyFrames.cs
- SqlColumnizer.cs
- LinqExpressionNormalizer.cs
- PopOutPanel.cs
- LockRecoveryTask.cs
- CommonRemoteMemoryBlock.cs
- WebSysDisplayNameAttribute.cs
- SspiHelper.cs
- ThousandthOfEmRealPoints.cs
- QilInvokeLateBound.cs
- XmlAnyAttributeAttribute.cs
- HtmlShim.cs
- BoundsDrawingContextWalker.cs
- BoundConstants.cs
- FrameworkContentElement.cs
- RedirectionProxy.cs
- ImageSource.cs
- DataContractSerializerFaultFormatter.cs
- CodeDomConfigurationHandler.cs
- SqlConnectionPoolGroupProviderInfo.cs
- CrossContextChannel.cs
- dtdvalidator.cs
- PenCursorManager.cs
- EncoderExceptionFallback.cs
- XsdValidatingReader.cs
- CopyAction.cs
- AdRotator.cs
- LocalClientSecuritySettings.cs
- XamlParser.cs
- SingleObjectCollection.cs
- HttpServerVarsCollection.cs
- EditorPartCollection.cs
- DateTimePicker.cs
- RegexReplacement.cs
- Pts.cs
- MenuItemCollection.cs
- MergeFailedEvent.cs
- AssemblyBuilderData.cs
- AnonymousIdentificationModule.cs
- CheckBoxStandardAdapter.cs
- ConfigPathUtility.cs
- externdll.cs
- XmlSchemaProviderAttribute.cs
- WorkflowPrinting.cs
- SortQuery.cs
- TypePropertyEditor.cs
- Typography.cs
- BitmapEffectInput.cs