DataConnectionHelper.cs source code in C# .NET

Source code for the .NET framework in C#

                        
Code:

                         / FXUpdate3074 / FXUpdate3074 / 1.1 / untmp / 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
  1. " + resourceString + "
    2. \n";
 
                switch (_Error)
                {
                    case DataConnectionErrorEnum.CanNotCreateDataDir:
                        resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotCreateDataDir); 
                        miscContent += "
  2. " + resourceString + "
    3. \n";
 
                        resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2); 
                        miscContent += "
  3. " + resourceString + "
    4. \n";
                        break; 

                    case DataConnectionErrorEnum.CanNotWriteToDataDir:
                        resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2);
                        miscContent += "
  4. " + resourceString + "
    5. \n"; 
                        break;
 
                    case DataConnectionErrorEnum.CanNotWriteToDBFile: 
                        resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotWriteToDBFile_a);
                        miscContent += "
  5. " + resourceString + "
    6. \n"; 

                        resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_2_CanNotWriteToDBFile_b);
                        miscContent += "
  6. " + resourceString + "
    7. \n";
                        break; 
                }
                resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_3); 
                miscContent += "
  7. " + resourceString + "
    8. \n"; 

                url = AssemblyResourceLoader.GetWebResourceUrl(typeof(Page), "properties_security_tab.gif", true); 
                miscContent += "




    ";

                resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickAdd);
                miscContent += "
  8. " + resourceString + "
    9. \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 += "
  9. " + four + "
    10. \n";
 
                resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickOK); 
                miscContent += "
  10. " + resourceString + "
    11. \n";
 
                resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_5);
                miscContent += "
  11. " + resourceString + "
    12. \n";

                url = AssemblyResourceLoader.GetWebResourceUrl(typeof(Page), "properties_security_tab_w_user.gif", true); 
                miscContent += "



    ";
 
                resourceString = GetResourceStringAndSetAdaptiveNumberedText(ref currentNumber, SR.DataAccessError_MiscSection_ClickOK); 
                miscContent += "
  12. " + resourceString + "
    13. \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 += "
    1. " + resourceString + "
      2. \n"; 
                            resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_2 );
                            s_errMessage += "
    2. " + resourceString + "
      3. \n";
                            resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_3 );
                            s_errMessage += "
    3. " + resourceString + "
      4. \n"; 
                            resourceString = SR.GetString( SR.SqlExpress_MDF_File_Auto_Creation_4 );
                            s_errMessage += "
    4. " + resourceString + "
      5. \n"; 
                            s_errMessage += "
    \n"; 
                        }
                    } 
                }

                return s_errMessage;
            } 
        }
    } 
} 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
// Copyright (c) Microsoft Corporation. All rights reserved.

Link Menu

Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
This book is available now!
Buy at Amazon US or
Buy at Amazon UK