Application.FolderExistsOnSqlServer Yöntemi
Döndürür bir Boole belirtilen klasör üzerinde zaten olup olmadığını belirten örnek , SQL Server.
Ad Alanı: Microsoft.SqlServer.Dts.Runtime
Derleme: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS içinde.dll)
Sözdizimi
'Bildirim
Public Function FolderExistsOnSqlServer ( _
strFolderName As String, _
strServerName As String, _
strServerUserName As String, _
strServerPassword As String _
) As Boolean
'Kullanım
Dim instance As Application
Dim strFolderName As String
Dim strServerName As String
Dim strServerUserName As String
Dim strServerPassword As String
Dim returnValue As Boolean
returnValue = instance.FolderExistsOnSqlServer(strFolderName, _
strServerName, strServerUserName, _
strServerPassword)
public bool FolderExistsOnSqlServer(
string strFolderName,
string strServerName,
string strServerUserName,
string strServerPassword
)
public:
bool FolderExistsOnSqlServer(
String^ strFolderName,
String^ strServerName,
String^ strServerUserName,
String^ strServerPassword
)
member FolderExistsOnSqlServer :
strFolderName:string *
strServerName:string *
strServerUserName:string *
strServerPassword:string -> bool
public function FolderExistsOnSqlServer(
strFolderName : String,
strServerName : String,
strServerUserName : String,
strServerPassword : String
) : boolean
Parametreler
- strFolderName
Tür: System.String
Aradığınız klasör.
- strServerName
Tür: System.String
Adı örnek , SQL Server Arama paket.
- strServerUserName
Tür: System.String
SQL Server Oturum açma adı kullanırsanız SQL Server ; sunucuya oturum açmak için kimlik doğrulama Aksi takdirde, nullnull başvuru (Visual Basic'te Nothing) , Windows kimlik doğrulaması kullanıyorsanız.
- strServerPassword
Tür: System.String
SQL Server Oturum açma parolası kullanırsanız SQL Server ; sunucuda oturum kimlik doğrulaması Aksi takdirde, nullnull başvuru (Visual Basic'te Nothing) , Windows kimlik doğrulaması kullanıyorsanız.
Dönüş Değeri
Tür: System.Boolean
doğru klasörü üzerinde belirtilen örnek varsa SQL Server; yanlış klasörü yoksa.
Örnekler
Aşağıdaki kod örneği üzerinde bir klasör oluşturur SQL Server, onu yeniden adlandırır ve ardından it. ortadan kaldırırAyrıca klasörü varlığını kullanarak doğrular FolderExistsOnSqlServer.
static void Main(string[] args)
{
// The variable pkg points to the location
// of the ExecuteProcess package sample
// that is installed with the SSIS samples.
string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
Application app = new Application();
app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", null, null);
// Verify that the folder was created.
Boolean ssFolder = app.FolderExistsOnSqlServer("\\myNewFolder", "yourserver", null, null);
Console.WriteLine("myNewFolderExists? " + ssFolder);
// Rename the myNewFolder to myRenamedFolder.
app.RenameFolderOnSqlServer("\\", "myNewFolder", "myRenamedFolder", "yourserver", null, null);
// Verify that the old folder does not exist.
ssFolder = app.FolderExistsOnSqlServer("\\myNewFolder", "yourserver", null, null);
Console.WriteLine("myNewFolderExists has been renamed but still exists? " + ssFolder);
// Verify that a folder with the new name does exist.
ssFolder = app.FolderExistsOnSqlServer("\\myRenamedFolder", "yourserver", null, null);
Console.WriteLine("myRenamedFolder now exists? " + ssFolder);
// Delete the folder.
app.RemoveFolderFromSqlServer("\\myRenamedFolder", "yourserver", null, null);
// Verify that the folder was removed.
ssFolder = app.FolderExistsOnSqlServer("\\myRenamedFolder", "yourserver", null, null);
Console.WriteLine("myRenamedFolder still exists? " + ssFolder);
}
Sub Main(ByVal args() As String)
' The variable pkg points to the location
' of the ExecuteProcess package sample
' that is installed with the SSIS samples.
Dim pkg As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
Dim app As Application = New Application()
app.CreateFolderOnSqlServer("\\", "myNewFolder", "yourserver", Nothing, Nothing)
' Verify that the folder was created.
Dim ssFolder As Boolean = app.FolderExistsOnSqlServer("\\myNewFolder","yourserver",Nothing,Nothing)
Console.WriteLine("myNewFolderExists? " + ssFolder)
' Rename the myNewFolder to myRenamedFolder.
app.RenameFolderOnSqlServer("\\", "myNewFolder", "myRenamedFolder", "yourserver", Nothing, Nothing)
' Verify that the old folder does not exist.
ssFolder = app.FolderExistsOnSqlServer("\\myNewFolder", "yourserver", Nothing, Nothing)
Console.WriteLine("myNewFolderExists has been renamed but still exists? " + ssFolder)
' Verify that a folder with the new name does exist.
ssFolder = app.FolderExistsOnSqlServer("\\myRenamedFolder", "yourserver", Nothing, Nothing)
Console.WriteLine("myRenamedFolder now exists? " + ssFolder)
' Delete the folder.
app.RemoveFolderFromSqlServer("\\myRenamedFolder", "yourserver", Nothing, Nothing)
' Verify that the folder was removed.
ssFolder = app.FolderExistsOnSqlServer("\\myRenamedFolder", "yourserver", Nothing, Nothing)
Console.WriteLine("myRenamedFolder still exists? " + ssFolder)
End Sub
Örnek Çıktı:
myNewFolderExists? True
myNewFolderExists has been renamed but still exists? False
myRenamedFolder now exists? True
myRenamedFolder still exists? False