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
- Point4D.cs
- ReadOnlyDictionary.cs
- AgileSafeNativeMemoryHandle.cs
- MasterPage.cs
- XmlSerializerAssemblyAttribute.cs
- XmlLanguage.cs
- ValidatorCollection.cs
- ErrorHandlingReceiver.cs
- SessionEndedEventArgs.cs
- EncodingTable.cs
- HttpResponseHeader.cs
- oledbmetadatacolumnnames.cs
- HtmlProps.cs
- XmlAttributeProperties.cs
- EntityReference.cs
- MinMaxParagraphWidth.cs
- ContextProperty.cs
- StrongName.cs
- TransformCollection.cs
- BypassElement.cs
- ClockGroup.cs
- MethodBody.cs
- InsufficientMemoryException.cs
- TreeNodeEventArgs.cs
- FontDialog.cs
- TextProviderWrapper.cs
- ZipIOLocalFileBlock.cs
- ConnectionProviderAttribute.cs
- PermissionRequestEvidence.cs
- TableItemPattern.cs
- NavigatorInput.cs
- EnumValAlphaComparer.cs
- ClientTargetSection.cs
- Trace.cs
- Version.cs
- TriggerCollection.cs
- DbSourceParameterCollection.cs
- httpstaticobjectscollection.cs
- SqlUDTStorage.cs
- ErrorsHelper.cs
- _BaseOverlappedAsyncResult.cs
- LinqDataView.cs
- SQLGuid.cs
- CanExecuteRoutedEventArgs.cs
- HttpListenerContext.cs
- RunClient.cs
- DataAdapter.cs
- DynamicRenderer.cs
- SoapAttributeOverrides.cs
- RSAOAEPKeyExchangeFormatter.cs
- StringAnimationBase.cs
- XmlElementAttributes.cs
- ListItem.cs
- ResXDataNode.cs
- ListBoxItemAutomationPeer.cs
- ColorEditor.cs
- TargetException.cs
- CompilerGlobalScopeAttribute.cs
- Rect3DValueSerializer.cs
- FloaterParagraph.cs
- SafeFindHandle.cs
- VisualTransition.cs
- QuerySettings.cs
- CodeSnippetStatement.cs
- WorkflowRuntime.cs
- ImportedNamespaceContextItem.cs
- PartialClassGenerationTask.cs
- XPathException.cs
- XmlEncoding.cs
- ScriptBehaviorDescriptor.cs
- Decimal.cs
- NativeMethods.cs
- HostingPreferredMapPath.cs
- DictionaryKeyPropertyAttribute.cs
- View.cs
- FamilyMap.cs
- GetPageNumberCompletedEventArgs.cs
- HttpCapabilitiesSectionHandler.cs
- ViewService.cs
- PeerApplication.cs
- DelegateHelpers.Generated.cs
- WebPartEditVerb.cs
- safex509handles.cs
- Brushes.cs
- DesignerLoader.cs
- BooleanProjectedSlot.cs
- BindingGroup.cs
- DataSourceHelper.cs
- ExpressionTextBox.xaml.cs
- IDReferencePropertyAttribute.cs
- DocumentXmlWriter.cs
- TextWriter.cs
- LocalizabilityAttribute.cs
- TrackingStringDictionary.cs
- SynchronizedDispatch.cs
- MenuItemCollection.cs
- SafeSystemMetrics.cs
- SimpleExpression.cs
- UnsafeNetInfoNativeMethods.cs
- HtmlInputSubmit.cs