UITypeName 屬性

Returns the name of the connection type that is shown in the graphical user interface. This value is read-only.

命名空間：  Microsoft.SqlServer.Dts.Runtime
組件：  Microsoft.SqlServer.ManagedDTS (在 Microsoft.SqlServer.ManagedDTS.dll 中)

語法

'宣告
Public ReadOnly Property UITypeName As String
    Get
'用途
Dim instance As ConnectionInfo
Dim value As String

value = instance.UITypeName

public string UITypeName { get; }

public:
property String^ UITypeName {
    String^ get ();
}

member UITypeName : string

function get UITypeName () : String

屬性值

型別：System. . :: . .String
A String that contains the connection type value that is shown in the user interface.

範例

The following code example creates an Application object, iterates through the default connections on the computer and then lists the properties of each connection. In this example, the UITypeName is shown as "Microsoft.DataTransformationServices.Design.SingleFileConnectionManagerUI, Microsoft.DataTransformationServices.Design, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91".

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace ConnInfoTest
{
    class Program
    {
        static void Main(string[] args)
        {
            Application dtsApplication = new Application();
            ConnectionInfos connectionInfos = dtsApplication.ConnectionInfos;

            foreach (ConnectionInfo connInfo in connectionInfos)
            {
                Console.WriteLine(connInfo.ConnectionContact);
                Console.WriteLine(connInfo.ConnectionType);
                Console.WriteLine(connInfo.CreationName);
                Console.WriteLine(connInfo.Description);
                Console.WriteLine(connInfo.FileName);
                //Console.WriteLine(connInfo.FileNameVersionString);
                Console.WriteLine(connInfo.IconFile);
                Console.WriteLine(connInfo.IconResource);
                Console.WriteLine(connInfo.ID);
                Console.WriteLine(connInfo.Name);
                Console.WriteLine(connInfo.UITypeName);
            }
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace ConnInfoTest
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim dtsApplication As Application =  New Application() 
            Dim connectionInfos As ConnectionInfos =  dtsApplication.ConnectionInfos 
 
            Dim connInfo As ConnectionInfo
            For Each connInfo In connectionInfos
                Console.WriteLine(connInfo.ConnectionContact)
                Console.WriteLine(connInfo.ConnectionType)
                Console.WriteLine(connInfo.CreationName)
                Console.WriteLine(connInfo.Description)
                Console.WriteLine(connInfo.FileName)
                'Console.WriteLine(connInfo.FileNameVersionString)
                Console.WriteLine(connInfo.IconFile)
                Console.WriteLine(connInfo.IconResource)
                Console.WriteLine(connInfo.ID)
                Console.WriteLine(connInfo.Name)
                Console.WriteLine(connInfo.UITypeName)
            Next
        End Sub
    End Class
End Namespace

Sample Output:

Microsoft Corporation

FILE

DTS.ConnectionManagerFile.2

Connection Manager for Files

C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DtsConn.dll

C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DtsConn.dll

0

{41F5EFE4-E91A-4EB0-BF10-D40FD48B3C03}

DTS Connection Manager for Files

Microsoft.DataTransformationServices.Design.SingleFileConnectionManagerUI,

Microsoft.DataTransformationServices.Design, Version=10.0.000.0,

Culture=neutral, PublicKeyToken=89845dcd8080cc91

請參閱

參考

ConnectionInfo 類別

Microsoft.SqlServer.Dts.Runtime 命名空間