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
- MenuItemStyleCollection.cs
- DataTableNewRowEvent.cs
- MetadataCacheItem.cs
- DataGridLength.cs
- LabelEditEvent.cs
- DbDeleteCommandTree.cs
- PointValueSerializer.cs
- LinkDescriptor.cs
- ConfigurationConverterBase.cs
- StringArrayConverter.cs
- MethodBuilder.cs
- DataKeyArray.cs
- SerializationException.cs
- Msec.cs
- MailBnfHelper.cs
- SetIndexBinder.cs
- Site.cs
- BitmapDecoder.cs
- XPathNodeHelper.cs
- ByteConverter.cs
- PropertyContainer.cs
- PagePropertiesChangingEventArgs.cs
- SqlClientWrapperSmiStream.cs
- LogSwitch.cs
- SystemUnicastIPAddressInformation.cs
- SessionSymmetricMessageSecurityProtocolFactory.cs
- HashFinalRequest.cs
- ResourceWriter.cs
- SchemaContext.cs
- xmlsaver.cs
- ClientSettings.cs
- XmlNodeChangedEventManager.cs
- ChangePassword.cs
- DBNull.cs
- FirstQueryOperator.cs
- Workspace.cs
- TraceHandler.cs
- PhysicalAddress.cs
- DocumentGrid.cs
- ProviderException.cs
- DataGridViewCheckBoxCell.cs
- ReaderWriterLockWrapper.cs
- StandardMenuStripVerb.cs
- ListViewItem.cs
- RawStylusInputCustomData.cs
- EngineSite.cs
- XamlBuildTaskServices.cs
- XmlSchemaAll.cs
- _SSPISessionCache.cs
- TableRow.cs
- GenericRootAutomationPeer.cs
- Header.cs
- JumpPath.cs
- FixedHighlight.cs
- DiscoveryClientChannelFactory.cs
- MessageEventSubscriptionService.cs
- WebPartConnectVerb.cs
- XmlnsDefinitionAttribute.cs
- ConfigXmlElement.cs
- CodeGen.cs
- SmiXetterAccessMap.cs
- DetailsViewRow.cs
- GlobalEventManager.cs
- TemplateBamlTreeBuilder.cs
- OutputScopeManager.cs
- TTSEngineProxy.cs
- arclist.cs
- WebUtil.cs
- ExitEventArgs.cs
- WindowsPen.cs
- CqlIdentifiers.cs
- GeometryValueSerializer.cs
- MetadataException.cs
- DragDeltaEventArgs.cs
- XmlChildNodes.cs
- _ProxyRegBlob.cs
- XmlSchemaGroupRef.cs
- RelationshipEndMember.cs
- CustomLineCap.cs
- EmptyEnumerable.cs
- OutOfProcStateClientManager.cs
- AttributeProviderAttribute.cs
- ViewGenerator.cs
- MediaContextNotificationWindow.cs
- BrowserCapabilitiesFactory.cs
- FloatMinMaxAggregationOperator.cs
- ToolStripProgressBar.cs
- EventMappingSettings.cs
- Transactions.cs
- TcpAppDomainProtocolHandler.cs
- SetterTriggerConditionValueConverter.cs
- BindingManagerDataErrorEventArgs.cs
- DictionaryContent.cs
- GroupByQueryOperator.cs
- GeneralTransform.cs
- InternalsVisibleToAttribute.cs
- WsatTransactionInfo.cs
- HttpDebugHandler.cs
- ListBoxItemWrapperAutomationPeer.cs
- ServicePointManager.cs