Code:
/ FX-1434 / FX-1434 / 1.0 / untmp / whidbey / REDBITS / ndp / fx / src / Designer / WebForms / System / Web / UI / Design / ConnectionStringsExpressionEditor.cs / 1 / ConnectionStringsExpressionEditor.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //----------------------------------------------------------------------------- namespace System.Web.UI.Design { using System; using System.Collections; using System.ComponentModel; using System.Configuration; using System.Design; using System.Globalization; ///public class ConnectionStringsExpressionEditor : ExpressionEditor { // Gets the collection of connection strings from config private ConnectionStringSettingsCollection GetConnectionStringSettingsCollection(IServiceProvider serviceProvider) { if (serviceProvider != null) { IWebApplication webApp = (IWebApplication)serviceProvider.GetService(typeof(IWebApplication)); if (webApp != null) { Configuration config = webApp.OpenWebConfiguration(true); if (config != null) { ConnectionStringsSection connSection = (ConnectionStringsSection)config.GetSection("connectionStrings"); if (connSection != null) { return connSection.ConnectionStrings; } } } } return null; } public override ExpressionEditorSheet GetExpressionEditorSheet(string expression, IServiceProvider serviceProvider) { return new ConnectionStringsExpressionEditorSheet(expression, this, serviceProvider); } /// public override object EvaluateExpression(string expression, object parseTimeData, Type propertyType, IServiceProvider serviceProvider) { Pair p = (Pair)parseTimeData; string name = (string)p.First; bool isConnectionString = (bool)p.Second; ConnectionStringSettingsCollection connections = GetConnectionStringSettingsCollection(serviceProvider); ConnectionStringSettings setting = null; foreach (ConnectionStringSettings item in connections) { if (String.Equals(name, item.Name, StringComparison.OrdinalIgnoreCase)) { setting = item; break; } } if (setting != null) { if (isConnectionString) { return setting.ConnectionString; } else { return setting.ProviderName; } } // If we couldn't find a connection, just return null return null; } private static string ParseExpression(string expression, out bool isConnectionString) { // Copied from ConnectionStringsExpressionBuilder.ParseExpression() const string connectionStringSuffix = ".connectionstring"; const string providerNameSuffix = ".providername"; isConnectionString = true; expression = expression.Trim(); if (expression.EndsWith(connectionStringSuffix, StringComparison.OrdinalIgnoreCase)) { return expression.Substring(0, expression.Length - connectionStringSuffix.Length); } else { if (expression.EndsWith(providerNameSuffix, StringComparison.OrdinalIgnoreCase)) { isConnectionString = false; return expression.Substring(0, expression.Length - providerNameSuffix.Length); } else { return expression; } } } private class ConnectionStringsExpressionEditorSheet : ExpressionEditorSheet { private string _connectionName; private ConnectionType _connectionType; private ConnectionStringsExpressionEditor _owner; public ConnectionStringsExpressionEditorSheet(string expression, ConnectionStringsExpressionEditor owner, IServiceProvider serviceProvider) : base(serviceProvider) { _owner = owner; bool isConnectionString; _connectionName = ParseExpression(expression, out isConnectionString); _connectionType = (isConnectionString ? ConnectionType.ConnectionString : ConnectionType.ProviderName); } [DefaultValue("")] [SRDescription(SR.ConnectionStringsExpressionEditor_ConnectionName)] [TypeConverter(typeof(ConnectionStringsTypeConverter))] public string ConnectionName { get { return _connectionName; } set { _connectionName = value; } } public override bool IsValid { get { return !String.IsNullOrEmpty(ConnectionName); } } [DefaultValue(ConnectionType.ConnectionString)] [SRDescription(SR.ConnectionStringsExpressionEditor_ConnectionType)] public ConnectionType Type { get { return _connectionType; } set { _connectionType = value; } } public override string GetExpression() { if (String.IsNullOrEmpty(_connectionName)) { return String.Empty; } string expression = _connectionName; if (Type == ConnectionType.ProviderName) { expression += ".ProviderName"; } return expression; } public enum ConnectionType { ConnectionString = 0, ProviderName = 1 } private class ConnectionStringsTypeConverter : TypeConverter { private static readonly string NoConnectionName = "(None)"; public override bool CanConvertFrom(ITypeDescriptorContext context, Type sourceType) { if (sourceType == typeof(string)) { return true; } return base.CanConvertFrom(context, sourceType); } public override object ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, object value) { if (value is string) { if (String.Equals((string)value, NoConnectionName, StringComparison.OrdinalIgnoreCase)) { return String.Empty; } return value; } return base.ConvertFrom(context, culture, value); } public override bool CanConvertTo(ITypeDescriptorContext context, Type destType) { if (destType == typeof(string)) { return true; } return base.CanConvertTo(context, destType); } public override object ConvertTo(ITypeDescriptorContext context, CultureInfo culture, object value, Type destinationType) { if (value is string) { if (((string)value).Length == 0) { return NoConnectionName; } return value; } return base.ConvertTo(context, culture, value, destinationType); } public override bool GetStandardValuesExclusive(ITypeDescriptorContext context) { return false; } public override bool GetStandardValuesSupported(ITypeDescriptorContext context) { if (context != null) { ConnectionStringsExpressionEditorSheet sheet = (ConnectionStringsExpressionEditorSheet)context.Instance; ConnectionStringsExpressionEditor csee = sheet._owner; ConnectionStringSettingsCollection connectionsColl = csee.GetConnectionStringSettingsCollection(sheet.ServiceProvider); if (connectionsColl != null) { return (connectionsColl.Count > 0); } } return base.GetStandardValuesSupported(context); } public override StandardValuesCollection GetStandardValues(ITypeDescriptorContext context) { if (context != null) { ConnectionStringsExpressionEditorSheet sheet = (ConnectionStringsExpressionEditorSheet)context.Instance; ConnectionStringsExpressionEditor csee = sheet._owner; ConnectionStringSettingsCollection connectionsColl = csee.GetConnectionStringSettingsCollection(sheet.ServiceProvider); if (connectionsColl != null) { ArrayList valueList = new ArrayList(); foreach (ConnectionStringSettings setting in connectionsColl) { valueList.Add(setting.Name); } valueList.Sort(); valueList.Add(String.Empty); return new StandardValuesCollection(valueList); } } return base.GetStandardValues(context); } } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. // Copyright (c) Microsoft Corporation. All rights reserved.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- TypedDataSetSchemaImporterExtensionFx35.cs
- RelationshipSet.cs
- DataGridViewCellValidatingEventArgs.cs
- WinEventTracker.cs
- TrustLevelCollection.cs
- DataSourceControlBuilder.cs
- SecurityKeyIdentifier.cs
- Freezable.cs
- UniqueConstraint.cs
- ProbeDuplexAsyncResult.cs
- ContainerTracking.cs
- PropertyTabChangedEvent.cs
- RemoteEndpointMessageProperty.cs
- RoutedCommand.cs
- BaseTemplateParser.cs
- ContentPresenter.cs
- SelectionPattern.cs
- BooleanStorage.cs
- SystemIcons.cs
- ProfileParameter.cs
- PostBackOptions.cs
- UrlParameterReader.cs
- HttpGetProtocolImporter.cs
- SafeArrayRankMismatchException.cs
- ScriptReferenceBase.cs
- BlockExpression.cs
- Connector.cs
- OdbcParameterCollection.cs
- DataGridViewCellCollection.cs
- TextElementAutomationPeer.cs
- MetadataArtifactLoaderCompositeFile.cs
- ZipIOLocalFileDataDescriptor.cs
- PriorityRange.cs
- DecimalAnimationUsingKeyFrames.cs
- RijndaelManagedTransform.cs
- HttpDebugHandler.cs
- ResXResourceSet.cs
- Events.cs
- BamlResourceContent.cs
- WebRequestModuleElement.cs
- StructuredProperty.cs
- CachedBitmap.cs
- SerialReceived.cs
- SplitContainerDesigner.cs
- ValidateNames.cs
- UnsafeNativeMethods.cs
- keycontainerpermission.cs
- StreamWriter.cs
- WsatConfiguration.cs
- HttpHandlerAction.cs
- Parameter.cs
- StatusBarItem.cs
- SystemBrushes.cs
- EventTrigger.cs
- WebPartTracker.cs
- _BufferOffsetSize.cs
- DummyDataSource.cs
- StubHelpers.cs
- FormsAuthenticationModule.cs
- TimelineClockCollection.cs
- XPathDocumentBuilder.cs
- DataGridViewCellMouseEventArgs.cs
- TableRow.cs
- ControlLocalizer.cs
- StringToken.cs
- RTLAwareMessageBox.cs
- ThreadExceptionDialog.cs
- DelegateSerializationHolder.cs
- DesignTimeDataBinding.cs
- InputBinding.cs
- BinaryExpression.cs
- NavigatingCancelEventArgs.cs
- Duration.cs
- ImageSourceConverter.cs
- SQLChars.cs
- TemplateField.cs
- HasCopySemanticsAttribute.cs
- RelatedEnd.cs
- EventLogHandle.cs
- WindowPatternIdentifiers.cs
- XmlAttributeProperties.cs
- InheritedPropertyChangedEventArgs.cs
- OleServicesContext.cs
- ComplexBindingPropertiesAttribute.cs
- FixedSOMImage.cs
- BitmapEffectDrawing.cs
- SHA256.cs
- TreeViewAutomationPeer.cs
- Vector3DAnimation.cs
- ModelFunctionTypeElement.cs
- ContentElement.cs
- HwndTarget.cs
- MessageAction.cs
- ActionMismatchAddressingException.cs
- UnmanagedMarshal.cs
- ChildChangedEventArgs.cs
- PropertyPathConverter.cs
- PrivacyNoticeBindingElementImporter.cs
- EncoderNLS.cs
- DefaultBindingPropertyAttribute.cs