Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / whidbey / netfxsp / ndp / fx / src / xsp / System / Web / UI / WebControls / FilteredDataSetHelper.cs / 5 / 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
- EventLogPermissionEntryCollection.cs
- DetailsViewDeleteEventArgs.cs
- DataGridBoolColumn.cs
- DateTimeParse.cs
- SqlLiftWhereClauses.cs
- UnsafeNativeMethods.cs
- DataGridViewButtonCell.cs
- RSAPKCS1KeyExchangeDeformatter.cs
- URLAttribute.cs
- PageAdapter.cs
- RenderContext.cs
- unsafenativemethodsother.cs
- BitmapMetadataEnumerator.cs
- ArraySortHelper.cs
- TypeConstant.cs
- EventToken.cs
- SessionPageStateSection.cs
- CorrelationToken.cs
- EnumerableRowCollectionExtensions.cs
- ContentIterators.cs
- CodeMethodReturnStatement.cs
- SqlCharStream.cs
- CodeSnippetStatement.cs
- TextSelectionProcessor.cs
- basenumberconverter.cs
- DataGridGeneralPage.cs
- FontInfo.cs
- AdornerHitTestResult.cs
- StateDesigner.CommentLayoutGlyph.cs
- ThrowHelper.cs
- OracleDateTime.cs
- ResourceFallbackManager.cs
- DataAdapter.cs
- ElementMarkupObject.cs
- Vector.cs
- XmlIterators.cs
- ZipIOLocalFileBlock.cs
- AdapterDictionary.cs
- MetafileHeaderWmf.cs
- PKCS1MaskGenerationMethod.cs
- WriteableBitmap.cs
- GridViewColumnCollection.cs
- SqlDataSourceCache.cs
- LinqDataSourceValidationException.cs
- InternalResources.cs
- PerformanceCounter.cs
- IdnElement.cs
- VersionedStream.cs
- SQLInt16Storage.cs
- FrameworkElement.cs
- DirectoryLocalQuery.cs
- LinqDataSourceStatusEventArgs.cs
- MD5.cs
- Polygon.cs
- FontCacheUtil.cs
- CaseCqlBlock.cs
- DataGridViewComboBoxEditingControl.cs
- IBuiltInEvidence.cs
- CompilerState.cs
- DynamicQueryStringParameter.cs
- EditorPartChrome.cs
- DataGridViewRowPrePaintEventArgs.cs
- FormatSettings.cs
- Boolean.cs
- FixedSOMImage.cs
- filewebrequest.cs
- WinEventHandler.cs
- DynamicDocumentPaginator.cs
- EncryptedPackage.cs
- TableProviderWrapper.cs
- DataSourceSelectArguments.cs
- DataGridViewCellFormattingEventArgs.cs
- XhtmlBasicCommandAdapter.cs
- DebugHandleTracker.cs
- AddingNewEventArgs.cs
- DeploymentExceptionMapper.cs
- MouseEventArgs.cs
- HijriCalendar.cs
- AsyncCompletedEventArgs.cs
- HtmlFormAdapter.cs
- DataControlFieldCell.cs
- TextSelectionHighlightLayer.cs
- ConnectionsZoneAutoFormat.cs
- ColorConvertedBitmapExtension.cs
- DebugInfo.cs
- CodeMemberEvent.cs
- OperatingSystem.cs
- EntitySqlQueryBuilder.cs
- SspiNegotiationTokenProviderState.cs
- CoreSwitches.cs
- UndoManager.cs
- UpDownBase.cs
- Tokenizer.cs
- WebPartRestoreVerb.cs
- Image.cs
- ACE.cs
- EncryptedData.cs
- SafeFindHandle.cs
- TextEffectResolver.cs
- ClockController.cs