Viewing Database Tools List

This method displays the existing database tools list on the Parallels Pro Control Panel server.

Method

public DatabaseToolData[] GetDatabaseToolsList (DatabaseToolType databasetooltype, string username, string password)

Parameters

  • databasetooltype, specifes type of database tools
  • username, which is the username of the service provider
  • password, which is the password of the service provider

Return Value

Array of DatabaseToolData objects with details of database tools of the specified database tool type.

Example Code:

DatabaseToolData[] dbToolData;

//for MsSql based tools

dbToolData = w.GetDatabaseToolsList(DatabaseToolType.MSSQL2005, "admin", "ensim123");

foreach (DatabaseToolData tool in dbToolData)

{

System.Console.WriteLine("Tool ID: " + tool.ID);

System.Console.WriteLine("Tool Name: " + tool.ToolName);

System.Console.WriteLine("Tool Type: " + tool.ToolType.ToString());

System.Console.WriteLine("Tool Target: " + tool.Target);

System.Console.WriteLine("Tool help Target: " + tool.HelpTarget);

}

//for MySql based tools

dbToolData = w.GetDatabaseToolsList(DatabaseToolType.MySQL, "admin", "ensim123");

foreach (DatabaseToolData tool in dbToolData)

{

System.Console.WriteLine("Tool ID: " + tool.ID);

System.Console.WriteLine("Tool Name: " + tool.ToolName);

System.Console.WriteLine("Tool Type: " + tool.ToolType.ToString());

System.Console.WriteLine("Tool Target: " + tool.Target);

System.Console.WriteLine("Tool help Target: " + tool.HelpTarget);

}

//for All types of DB tools

dbToolData = w.GetDatabaseToolsList(DatabaseToolType.All, "admin", "ensim123");

foreach (DatabaseToolData tool in dbToolData)

{

System.Console.WriteLine("Tool ID: " + tool.ID);

System.Console.WriteLine("Tool Name: " + tool.ToolName);

System.Console.WriteLine("Tool Type: " + tool.ToolType.ToString());

System.Console.WriteLine("Tool Target: " + tool.Target);

System.Console.WriteLine("Tool help Target: " + tool.HelpTarget);

}