DtsProperty.GetValue 메서드
Returns the value of the property.
네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS(Microsoft.SqlServer.ManagedDTS.dll)
구문
‘선언
Public Function GetValue ( _
o As Object _
) As Object
‘사용 방법
Dim instance As DtsProperty
Dim o As Object
Dim returnValue As Object
returnValue = instance.GetValue(o)
public Object GetValue(
Object o
)
public:
Object^ GetValue(
Object^ o
)
member GetValue :
o:Object -> Object
public function GetValue(
o : Object
) : Object
매개 변수
- o
유형: System.Object
The parent object of the property whose value is to be returned.
반환 값
유형: System.Object
An object that contains the value of the property.
주의
When you request the value of a property by calling the GetValue method, the object that you must pass as a parameter is the object to which the property belongs. For example, if you are working with an OLE DB connection manager as shown in the following example, and you have created a DtsProperty object for its ServerName property, then you would pass the connection manager object as the parameter to the GetValue method.
예
using System;
using Microsoft.SqlServer.Dts.Runtime;
namespace DtsPropertyGetValueCS
{
class Program
{
static void Main(string[] args)
{
Package testPackage;
ConnectionManager testConnection;
DtsProperty testProperty;
string propertyValue;
testPackage = new Package();
testConnection = testPackage.Connections.Add("OLEDB");
testConnection.ConnectionString = "Provider=SQLOLEDB;" +
"Data Source=(local);Initial Catalog=AdventureWorks;" +
"Integrated Security=SSPI";
testConnection.Name = "Test Connection Manager";
testProperty = testConnection.Properties["ServerName"];
propertyValue = testProperty.GetValue(testConnection).ToString();
Console.WriteLine("The value of ServerName is: " + propertyValue);
Console.Read();
}
}
}
Imports Microsoft.SqlServer.Dts.Runtime
Module Module1
Sub Main()
Dim testPackage As Package
Dim testConnection As ConnectionManager
Dim testProperty As DtsProperty
Dim propertyValue As String
testPackage = New Package()
testConnection = testPackage.Connections.Add("OLEDB")
testConnection.ConnectionString = "Provider=SQLOLEDB;" & _
"Data Source=(local);Initial Catalog=AdventureWorks;" & _
"Integrated Security=SSPI"
testConnection.Name = "Test Connection Manager"
testProperty = testConnection.Properties("ServerName")
propertyValue = testProperty.GetValue(testConnection).ToString()
Console.WriteLine("The value of ServerName is: " & propertyValue)
Console.Read()
End Sub
End Module