Code:
/ FXUpdate3074 / FXUpdate3074 / 1.1 / DEVDIV / depot / DevDiv / releases / whidbey / QFE / ndp / fx / src / xsp / System / Web / DataAccess / DataConnectionHelper.cs / 3 / DataConnectionHelper.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //----------------------------------------------------------------------------- using System; using System.Web.UI; [assembly:WebResource("add_permissions_for_users.gif", "image/gif")] [assembly:WebResource("properties_security_tab_w_user.gif", "image/gif")] [assembly:WebResource("properties_security_tab.gif", "image/gif")] namespace System.Web.DataAccess { using System; using System.Web; using System.Globalization; using System.Collections; using System.Collections.Specialized; using System.Data; using System.Data.OleDb; using System.IO; using System.Threading; using System.Configuration; using System.Web.Util; using System.Security.Permissions; using System.Web.Hosting; using System.Security.Principal; using System.Web.UI; using System.Web.Handlers; using System.Web.Configuration; using System.Diagnostics; using System.Text; ////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////// internal enum DataConnectionErrorEnum { CanNotCreateDataDir, CanNotWriteToDataDir, CanNotWriteToDBFile } internal static class DataConnectionHelper { internal static string GetCurrentName() { string userName = "NETWORK SERVICE"; string domainName = "NT AUTHORITY"; IntPtr pSid = IntPtr.Zero; try { if( UnsafeNativeMethods.ConvertStringSidToSid( "S-1-5-20", out pSid ) != 0 && pSid != IntPtr.Zero ) { int userNameLen = 256; int domainNameLen = 256; int sidNameUse = 0; StringBuilder bufUserName = new StringBuilder( userNameLen ); StringBuilder bufDomainName = new StringBuilder( domainNameLen ); if( 0 != UnsafeNativeMethods.LookupAccountSid( null, pSid, bufUserName, ref userNameLen, bufDomainName, ref domainNameLen, ref sidNameUse ) ) { userName = bufUserName.ToString(); domainName = bufDomainName.ToString(); } } WindowsIdentity id = WindowsIdentity.GetCurrent(); if( id != null && id.Name != null ) { if ( string.Compare( id.Name, domainName + @"\" + userName, StringComparison.OrdinalIgnoreCase ) == 0 ) { return userName; } return id.Name; } } catch {} finally { if( pSid != IntPtr.Zero ) { UnsafeNativeMethods.LocalFree( pSid ); } } return String.Empty; } } internal class DataConnectionErrorFormatter : ErrorFormatter { protected static NameValueCollection s_errMessages = new NameValueCollection(); protected static object s_Lock = new object (); protected string _UserName; protected DataConnectionErrorEnum _Error; protected override string ErrorTitle { get { return null; } } protected override string Description { get { return null; } } protected override string MiscSectionTitle { get { return SR.GetString ( SR.DataAccessError_MiscSectionTitle ); } } protected override string MiscSectionContent { get { string url; int currentNumber = 1; string resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_1); string miscContent = "\n
- " + resourceString + "
\n"; switch (_Error) { case DataConnectionErrorEnum.CanNotCreateDataDir: resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotCreateDataDir); miscContent += "- " + resourceString + "
\n"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2); miscContent += "- " + resourceString + "
\n"; break; case DataConnectionErrorEnum.CanNotWriteToDataDir: resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2); miscContent += "- " + resourceString + "
\n"; break; case DataConnectionErrorEnum.CanNotWriteToDBFile: resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotWriteToDBFile_a); miscContent += "- " + resourceString + "
\n"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotWriteToDBFile_b); miscContent += "- " + resourceString + "
\n"; break; } resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_3); miscContent += "- " + resourceString + "
\n"; url = AssemblyResourceLoader.GetWebResourceUrl(typeof(Page), "properties_security_tab.gif", true); miscContent += "
"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickAdd); miscContent += "- " + resourceString + "
\n"; url = AssemblyResourceLoader.GetWebResourceUrl(typeof(Page), "add_permissions_for_users.gif", true); miscContent += "
"; string four; if (!String.IsNullOrEmpty(_UserName)) four = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_4, _UserName); else four = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_4_2); miscContent += "- " + four + "
\n"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickOK); miscContent += "- " + resourceString + "
\n"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_5); miscContent += "- " + resourceString + "
\n"; url = AssemblyResourceLoader.GetWebResourceUrl(typeof(Page), "properties_security_tab_w_user.gif", true); miscContent += "
"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickOK); miscContent += "- " + resourceString + "
\n"; return miscContent; } } protected override string ColoredSquareTitle { get { return null; } } protected override string ColoredSquareContent { get { return null; } } protected override bool ShowSourceFileInfo { get { return false; } } private string GetResourceStringAndSetAdaptiveNumberedText(ref int currentNumber, string resourceId) { string resourceString = SR.GetString(resourceId); SetAdaptiveNumberedText(ref currentNumber, resourceString); return resourceString; } private string GetResourceStringAndSetAdaptiveNumberedText(ref int currentNumber, string resourceId, string parameter1) { string resourceString = SR.GetString(resourceId, parameter1); SetAdaptiveNumberedText(ref currentNumber, resourceString); return resourceString; } private void SetAdaptiveNumberedText(ref int currentNumber, string resourceString) { string adaptiveText = currentNumber.ToString(CultureInfo.InvariantCulture) + " " + resourceString; AdaptiveMiscContent.Add(adaptiveText); currentNumber += 1; } } internal sealed class SqlExpressConnectionErrorFormatter : DataConnectionErrorFormatter { internal SqlExpressConnectionErrorFormatter(DataConnectionErrorEnum error) { _UserName = (HttpRuntime.HasUnmanagedPermission() ? DataConnectionHelper.GetCurrentName() : String.Empty); _Error = error; } internal SqlExpressConnectionErrorFormatter(string userName, DataConnectionErrorEnum error) { _UserName = userName; _Error = error; } protected override string ErrorTitle { get { string resourceKey = null; switch ( _Error ) { case DataConnectionErrorEnum.CanNotCreateDataDir: resourceKey = SR.DataAccessError_CanNotCreateDataDir_Title; break; case DataConnectionErrorEnum.CanNotWriteToDataDir: resourceKey = SR.SqlExpressError_CanNotWriteToDataDir_Title; break; case DataConnectionErrorEnum.CanNotWriteToDBFile: resourceKey = SR.SqlExpressError_CanNotWriteToDbfFile_Title; break; } return SR.GetString (resourceKey); } } protected override string Description { get { string resourceKey1 = null; string resourceKey2 = null; switch (_Error) { case DataConnectionErrorEnum.CanNotCreateDataDir: resourceKey1 = SR.DataAccessError_CanNotCreateDataDir_Description; resourceKey2 = SR.DataAccessError_CanNotCreateDataDir_Description_2; break; case DataConnectionErrorEnum.CanNotWriteToDataDir: resourceKey1 = SR.SqlExpressError_CanNotWriteToDataDir_Description; resourceKey2 = SR.SqlExpressError_CanNotWriteToDataDir_Description_2; break; case DataConnectionErrorEnum.CanNotWriteToDBFile: resourceKey1 = SR.SqlExpressError_CanNotWriteToDbfFile_Description; resourceKey2 = SR.SqlExpressError_CanNotWriteToDbfFile_Description_2; break; } string desc; if (!String.IsNullOrEmpty(_UserName)) desc = SR.GetString (resourceKey1, _UserName); else desc = SR.GetString (resourceKey2); desc += " " + SR.GetString (SR.SqlExpressError_Description_1); return desc; } } } internal sealed class SqlExpressDBFileAutoCreationErrorFormatter : UnhandledErrorFormatter { static string s_errMessage = null; static object s_Lock = new object(); internal SqlExpressDBFileAutoCreationErrorFormatter( Exception exception ) : base( exception ) { } protected override string MiscSectionTitle { get { return SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_MiscSectionTitle ); } } protected override string MiscSectionContent { get { return CustomErrorMessage; } } internal static string CustomErrorMessage { get { if( s_errMessage == null ) { lock( s_Lock ) { if( s_errMessage == null ) { string resourceString; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation ); s_errMessage += "" + resourceString + "
\n"; s_errMessage += "\n"; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_1 ); s_errMessage += "
\n"; } } } return s_errMessage; } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. // Copyright (c) Microsoft Corporation. All rights reserved. //------------------------------------------------------------------------------ //- " + resourceString + "
\n"; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_2 ); s_errMessage += "- " + resourceString + "
\n"; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_3 ); s_errMessage += "- " + resourceString + "
\n"; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_4 ); s_errMessage += "- " + resourceString + "
\n"; s_errMessage += "// Copyright (c) Microsoft Corporation. All rights reserved. // //----------------------------------------------------------------------------- using System; using System.Web.UI; [assembly:WebResource("add_permissions_for_users.gif", "image/gif")] [assembly:WebResource("properties_security_tab_w_user.gif", "image/gif")] [assembly:WebResource("properties_security_tab.gif", "image/gif")] namespace System.Web.DataAccess { using System; using System.Web; using System.Globalization; using System.Collections; using System.Collections.Specialized; using System.Data; using System.Data.OleDb; using System.IO; using System.Threading; using System.Configuration; using System.Web.Util; using System.Security.Permissions; using System.Web.Hosting; using System.Security.Principal; using System.Web.UI; using System.Web.Handlers; using System.Web.Configuration; using System.Diagnostics; using System.Text; ////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////// internal enum DataConnectionErrorEnum { CanNotCreateDataDir, CanNotWriteToDataDir, CanNotWriteToDBFile } internal static class DataConnectionHelper { internal static string GetCurrentName() { string userName = "NETWORK SERVICE"; string domainName = "NT AUTHORITY"; IntPtr pSid = IntPtr.Zero; try { if( UnsafeNativeMethods.ConvertStringSidToSid( "S-1-5-20", out pSid ) != 0 && pSid != IntPtr.Zero ) { int userNameLen = 256; int domainNameLen = 256; int sidNameUse = 0; StringBuilder bufUserName = new StringBuilder( userNameLen ); StringBuilder bufDomainName = new StringBuilder( domainNameLen ); if( 0 != UnsafeNativeMethods.LookupAccountSid( null, pSid, bufUserName, ref userNameLen, bufDomainName, ref domainNameLen, ref sidNameUse ) ) { userName = bufUserName.ToString(); domainName = bufDomainName.ToString(); } } WindowsIdentity id = WindowsIdentity.GetCurrent(); if( id != null && id.Name != null ) { if ( string.Compare( id.Name, domainName + @"\" + userName, StringComparison.OrdinalIgnoreCase ) == 0 ) { return userName; } return id.Name; } } catch {} finally { if( pSid != IntPtr.Zero ) { UnsafeNativeMethods.LocalFree( pSid ); } } return String.Empty; } } internal class DataConnectionErrorFormatter : ErrorFormatter { protected static NameValueCollection s_errMessages = new NameValueCollection(); protected static object s_Lock = new object (); protected string _UserName; protected DataConnectionErrorEnum _Error; protected override string ErrorTitle { get { return null; } } protected override string Description { get { return null; } } protected override string MiscSectionTitle { get { return SR.GetString ( SR.DataAccessError_MiscSectionTitle ); } } protected override string MiscSectionContent { get { string url; int currentNumber = 1; string resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_1); string miscContent = "\n
- " + resourceString + "
\n"; switch (_Error) { case DataConnectionErrorEnum.CanNotCreateDataDir: resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotCreateDataDir); miscContent += "- " + resourceString + "
\n"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2); miscContent += "- " + resourceString + "
\n"; break; case DataConnectionErrorEnum.CanNotWriteToDataDir: resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2); miscContent += "- " + resourceString + "
\n"; break; case DataConnectionErrorEnum.CanNotWriteToDBFile: resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotWriteToDBFile_a); miscContent += "- " + resourceString + "
\n"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotWriteToDBFile_b); miscContent += "- " + resourceString + "
\n"; break; } resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_3); miscContent += "- " + resourceString + "
\n"; url = AssemblyResourceLoader.GetWebResourceUrl(typeof(Page), "properties_security_tab.gif", true); miscContent += "
"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickAdd); miscContent += "- " + resourceString + "
\n"; url = AssemblyResourceLoader.GetWebResourceUrl(typeof(Page), "add_permissions_for_users.gif", true); miscContent += "
"; string four; if (!String.IsNullOrEmpty(_UserName)) four = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_4, _UserName); else four = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_4_2); miscContent += "- " + four + "
\n"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickOK); miscContent += "- " + resourceString + "
\n"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_5); miscContent += "- " + resourceString + "
\n"; url = AssemblyResourceLoader.GetWebResourceUrl(typeof(Page), "properties_security_tab_w_user.gif", true); miscContent += "
"; resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickOK); miscContent += "- " + resourceString + "
\n"; return miscContent; } } protected override string ColoredSquareTitle { get { return null; } } protected override string ColoredSquareContent { get { return null; } } protected override bool ShowSourceFileInfo { get { return false; } } private string GetResourceStringAndSetAdaptiveNumberedText(ref int currentNumber, string resourceId) { string resourceString = SR.GetString(resourceId); SetAdaptiveNumberedText(ref currentNumber, resourceString); return resourceString; } private string GetResourceStringAndSetAdaptiveNumberedText(ref int currentNumber, string resourceId, string parameter1) { string resourceString = SR.GetString(resourceId, parameter1); SetAdaptiveNumberedText(ref currentNumber, resourceString); return resourceString; } private void SetAdaptiveNumberedText(ref int currentNumber, string resourceString) { string adaptiveText = currentNumber.ToString(CultureInfo.InvariantCulture) + " " + resourceString; AdaptiveMiscContent.Add(adaptiveText); currentNumber += 1; } } internal sealed class SqlExpressConnectionErrorFormatter : DataConnectionErrorFormatter { internal SqlExpressConnectionErrorFormatter(DataConnectionErrorEnum error) { _UserName = (HttpRuntime.HasUnmanagedPermission() ? DataConnectionHelper.GetCurrentName() : String.Empty); _Error = error; } internal SqlExpressConnectionErrorFormatter(string userName, DataConnectionErrorEnum error) { _UserName = userName; _Error = error; } protected override string ErrorTitle { get { string resourceKey = null; switch ( _Error ) { case DataConnectionErrorEnum.CanNotCreateDataDir: resourceKey = SR.DataAccessError_CanNotCreateDataDir_Title; break; case DataConnectionErrorEnum.CanNotWriteToDataDir: resourceKey = SR.SqlExpressError_CanNotWriteToDataDir_Title; break; case DataConnectionErrorEnum.CanNotWriteToDBFile: resourceKey = SR.SqlExpressError_CanNotWriteToDbfFile_Title; break; } return SR.GetString (resourceKey); } } protected override string Description { get { string resourceKey1 = null; string resourceKey2 = null; switch (_Error) { case DataConnectionErrorEnum.CanNotCreateDataDir: resourceKey1 = SR.DataAccessError_CanNotCreateDataDir_Description; resourceKey2 = SR.DataAccessError_CanNotCreateDataDir_Description_2; break; case DataConnectionErrorEnum.CanNotWriteToDataDir: resourceKey1 = SR.SqlExpressError_CanNotWriteToDataDir_Description; resourceKey2 = SR.SqlExpressError_CanNotWriteToDataDir_Description_2; break; case DataConnectionErrorEnum.CanNotWriteToDBFile: resourceKey1 = SR.SqlExpressError_CanNotWriteToDbfFile_Description; resourceKey2 = SR.SqlExpressError_CanNotWriteToDbfFile_Description_2; break; } string desc; if (!String.IsNullOrEmpty(_UserName)) desc = SR.GetString (resourceKey1, _UserName); else desc = SR.GetString (resourceKey2); desc += " " + SR.GetString (SR.SqlExpressError_Description_1); return desc; } } } internal sealed class SqlExpressDBFileAutoCreationErrorFormatter : UnhandledErrorFormatter { static string s_errMessage = null; static object s_Lock = new object(); internal SqlExpressDBFileAutoCreationErrorFormatter( Exception exception ) : base( exception ) { } protected override string MiscSectionTitle { get { return SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_MiscSectionTitle ); } } protected override string MiscSectionContent { get { return CustomErrorMessage; } } internal static string CustomErrorMessage { get { if( s_errMessage == null ) { lock( s_Lock ) { if( s_errMessage == null ) { string resourceString; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation ); s_errMessage += "" + resourceString + "
\n"; s_errMessage += "\n"; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_1 ); s_errMessage += "
\n"; } } } return s_errMessage; } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. // Copyright (c) Microsoft Corporation. All rights reserved.- " + resourceString + "
\n"; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_2 ); s_errMessage += "- " + resourceString + "
\n"; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_3 ); s_errMessage += "- " + resourceString + "
\n"; resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_4 ); s_errMessage += "- " + resourceString + "
\n"; s_errMessage += "
Link Menu

This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- ScrollItemPattern.cs
- TranslateTransform3D.cs
- ExpressionWriter.cs
- HttpCacheParams.cs
- InheritedPropertyChangedEventArgs.cs
- KerberosSecurityTokenAuthenticator.cs
- KnownColorTable.cs
- ParameterModifier.cs
- ClientRuntimeConfig.cs
- WebControlsSection.cs
- AncestorChangedEventArgs.cs
- GrowingArray.cs
- SetState.cs
- ProjectionQueryOptionExpression.cs
- MemberRelationshipService.cs
- RetriableClipboard.cs
- StateManagedCollection.cs
- DictionarySectionHandler.cs
- HTTPNotFoundHandler.cs
- BordersPage.cs
- FontFamily.cs
- SemanticBasicElement.cs
- DataTableReader.cs
- HtmlLiteralTextAdapter.cs
- DataServiceExpressionVisitor.cs
- MessageEnumerator.cs
- CacheRequest.cs
- DbProviderManifest.cs
- PageStatePersister.cs
- XmlStreamStore.cs
- ManagementOperationWatcher.cs
- SmtpException.cs
- SecurityManager.cs
- ConnectionsZoneAutoFormat.cs
- DockAndAnchorLayout.cs
- NamespaceList.cs
- ComplexPropertyEntry.cs
- Signature.cs
- MustUnderstandBehavior.cs
- translator.cs
- RSAPKCS1KeyExchangeFormatter.cs
- TextHintingModeValidation.cs
- ListViewItem.cs
- ClientFormsAuthenticationCredentials.cs
- OrderedDictionaryStateHelper.cs
- DropShadowEffect.cs
- WebPartConnectionsConfigureVerb.cs
- BindableTemplateBuilder.cs
- AttachInfo.cs
- Metadata.cs
- ConditionedDesigner.cs
- Stack.cs
- SmiEventSink_Default.cs
- XmlText.cs
- WriteFileContext.cs
- GeneralTransform2DTo3DTo2D.cs
- ProbeDuplexAsyncResult.cs
- TimelineCollection.cs
- XmlBinaryReaderSession.cs
- ToolBarPanel.cs
- TrustLevel.cs
- XPathSingletonIterator.cs
- Block.cs
- PagesSection.cs
- ResXDataNode.cs
- RuntimeDelegateArgument.cs
- MediaEntryAttribute.cs
- EntityContainerEntitySet.cs
- GridViewUpdatedEventArgs.cs
- CompiledQuery.cs
- QuotedStringWriteStateInfo.cs
- BindingOperations.cs
- Bitmap.cs
- OpenTypeLayout.cs
- TileBrush.cs
- DriveNotFoundException.cs
- FrameworkElementAutomationPeer.cs
- KeyPullup.cs
- ByteAnimationUsingKeyFrames.cs
- XmlArrayItemAttributes.cs
- ItemsPanelTemplate.cs
- SHA384Managed.cs
- DragEventArgs.cs
- SqlCacheDependency.cs
- QueryableFilterUserControl.cs
- XXXInfos.cs
- PerfCounterSection.cs
- RSAOAEPKeyExchangeDeformatter.cs
- HashCodeCombiner.cs
- SplitContainer.cs
- XmlObjectSerializerWriteContextComplex.cs
- InternalReceiveMessage.cs
- EventLogPermissionEntry.cs
- InvokeProviderWrapper.cs
- DataPagerField.cs
- PersonalizationProvider.cs
- SaveCardRequest.cs
- ObjectPersistData.cs
- QueryExecutionOption.cs
- FormatterConverter.cs