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.

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);

}