ConnectionInfo.ConnectionContact Property
Represents a writer-defined String. This value is read-only.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public ReadOnly Property ConnectionContact As String
Get
'Usage
Dim instance As ConnectionInfo
Dim value As String
value = instance.ConnectionContact
public string ConnectionContact { get; }
public:
property String^ ConnectionContact {
String^ get ();
}
member ConnectionContact : string
function get ConnectionContact () : String
Property Value
Type: System.String
A String that contains information put in by the developer. The value typically contains the contact information for the connection.
Examples
The following code example creates an Application object, and then iterates through the default connections on the computer and lists the properties of each connection. In this example, the ConnectionContact is shown as "Microsoft Corporation".
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.1
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