}//public void Server_Index_Changed(Object sender, EventArgs e)
/// <summary>ServerSelected()</summary>
public void ServerSelected()
{
bool system = false;
bool user = false;
string[] database = null;
string exceptionMessage = null;
string[] selectedServer = null;
string sqlServerLoginUserName = null;
string sqlServerPassword = null;
try
{
UtilityWebControl.SelectedItem
(
ListBoxServer,
ref selectedServer
);
if ( selectedServer == null || selectedServer.Length != 1 )
{
return;
}
ViewState["SQLServerManagementObjectsSMOPage_ServerSelectedFirst"] = selectedServer[0];
sqlServerLoginUserName = SQLServerLoginUserName;
sqlServerPassword = SQLServerPassword;
system = CheckBoxSystem.Checked;
user = CheckBoxUser.Checked;
UtilitySQLServerManagementObjectsSMO.DatabaseList
(
ref selectedServer[0],
ref exceptionMessage,
ref database,
ref sqlServerLoginUserName,
ref sqlServerPassword,
ref system,
ref user
);
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}//if ( exceptionMessage != null )
if ( database == null || database.Length < 1 )
{
return;
}//if ( database == null || database.Length < 1 )
ListBoxDatabase.DataSource = database;
ListBoxDatabase.DataBind();
}//try
catch ( System.Exception exception )
{
exceptionMessage = "System.Exception: " + exception.Message;
}//catch ( System.Exception exception )
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}//if ( exceptionMessage != null )
}//public void ServerSelected(Object sender, EventArgs e)
}//public void ButtonReset_Click()
/// <summary>WhoIsLookup</summary>
public void WhoIsLookup()
{
string exceptionMessage = null;
string[] registry = null;
StringBuilder[][] sbWhoIs = null;
StringBuilder sbJoin = null;
UtilityWhoIsPort43Argument utilityWhoIsPort43Argument = null;
try
{
UtilityWebControl.SelectedItem(ListBoxRegistry, ref registry);
utilityWhoIsPort43Argument = new UtilityWhoIsPort43Argument
(
RegistryDomainSuffixOnly,
PortWhoIs,
new string[] { DomainName },
registry
);
UtilityWhoIsPort43.WhoisLookup
(
ref utilityWhoIsPort43Argument,
ref sbWhoIs,
ref exceptionMessage
);
if (exceptionMessage != null)
{
Feedback = exceptionMessage; return;
}
sbJoin = new StringBuilder();
for (int indexDimension1 = 0; indexDimension1 < sbWhoIs.Length; ++indexDimension1)
{
for (int indexDimension2 = 0; indexDimension2 < sbWhoIs[indexDimension1].Length; ++indexDimension2)
{
sbJoin.Append(sbWhoIs[indexDimension1][indexDimension2]);
} //for ( int indexDimension2 = 0; indexDimension2 < sb[indexDimension1].Length; ++indexDimension2 )
} //for ( int indexDimension1 = 0; indexDimension1 < sb.Length; ++indexDimension1 )
} //try
catch (Exception exception) { exceptionMessage = exception.Message; }
if (exceptionMessage != null)
{
Feedback = exceptionMessage;
}
Feedback = sbJoin.ToString();
}//public void WhoIsLookup
}//public void Database_Index_Changed(Object sender, EventArgs e)
/// <summary>DatabaseSelected()</summary>
public void DatabaseSelected()
{
bool system = false;
bool user = false;
string serverSelectedFirst = null;
string exceptionMessage = null;
string[] defaultName = null;
string[] rule = null;
string[] selectedDatabase = null;
string sqlServerLoginUserName = null;
string sqlServerPassword = null;
string[] storedProcedure = null;
string[] table = null;
string[] trigger = null;
string[] userDefinedDataType = null;
string[] userDefinedFunction = null;
string[] view = null;
try
{
serverSelectedFirst = (string) ViewState["SQLServerManagementObjectsSMOPage_ServerSelectedFirst"];
if ( string.IsNullOrEmpty( serverSelectedFirst ) )
{
return;
}
UtilityWebControl.SelectedItem
(
ListBoxDatabase,
ref selectedDatabase
);
if ( selectedDatabase == null || selectedDatabase.Length != 1 )
{
return;
}
sqlServerLoginUserName = SQLServerLoginUserName;
sqlServerPassword = SQLServerPassword;
system = CheckBoxSystem.Checked;
user = CheckBoxUser.Checked;
UtilitySQLServerManagementObjectsSMO.DatabaseResource
(
ref serverSelectedFirst,
ref selectedDatabase[0],
ref exceptionMessage,
ref sqlServerLoginUserName,
ref sqlServerPassword,
ref system,
ref user,
ref defaultName,
ref rule,
ref storedProcedure,
ref table,
ref trigger,
ref userDefinedDataType,
ref userDefinedFunction,
ref view
);
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}//if ( exceptionMessage != null )
ListBoxDefault.DataSource = defaultName;
ListBoxDefault.DataBind();
ListBoxRule.DataSource = rule;
ListBoxRule.DataBind();
ListBoxStoredProcedure.DataSource = storedProcedure;
ListBoxStoredProcedure.DataBind();
ListBoxTable.DataSource = table;
ListBoxTable.DataBind();
ListBoxTrigger.DataSource = trigger;
ListBoxTrigger.DataBind();
ListBoxUserDefinedDataType.DataSource = userDefinedDataType;
ListBoxUserDefinedDataType.DataBind();
ListBoxUserDefinedFunction.DataSource = userDefinedFunction;
ListBoxUserDefinedFunction.DataBind();
ListBoxView.DataSource = view;
ListBoxView.DataBind();
}
catch ( System.Exception exception )
{
exceptionMessage = "System.Exception: " + exception.Message;
}
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}
}//public void DatabaseSelected()
}//public String public String Feedback
/// <summary>ButtonSubmit_Click().</summary>
public void ButtonSubmit_Click
(
Object sender,
EventArgs e
)
{
string[] defaultName = null;
string[] database = null;
String exceptionMessage = null;
string[] rule = null;
string[] server = null;
string[] storedProcedure = null;
string[] table = null;
string[] trigger = null;
string[] userDefinedDataType = null;
string[] userDefinedFunction = null;
string[] view = null;
UtilitySQLServerManagementObjectsSMOArgument UtilitySQLServerManagementObjectsSMOArgument = null;
/*
if( sender == ButtonSubmit )
{
Response.Write ( "ButtonSubmit" );
Feedback = "ButtonSubmit";
}
*/
try
{
UtilityWebControl.SelectedItem
(
ListBoxServer,
ref server
);
UtilityWebControl.SelectedItem
(
ListBoxDatabase,
ref database
);
UtilityWebControl.SelectedItem
(
ListBoxDefault,
ref defaultName
);
UtilityWebControl.SelectedItem
(
ListBoxRule,
ref rule
);
UtilityWebControl.SelectedItem
(
ListBoxStoredProcedure,
ref storedProcedure
);
UtilityWebControl.SelectedItem
(
ListBoxTable,
ref table
);
UtilityWebControl.SelectedItem
(
ListBoxTrigger,
ref trigger
);
UtilityWebControl.SelectedItem
(
ListBoxUserDefinedDataType,
ref userDefinedDataType
);
UtilityWebControl.SelectedItem
(
ListBoxUserDefinedFunction,
ref userDefinedFunction
);
UtilityWebControl.SelectedItem
(
ListBoxView,
ref view
);
UtilitySQLServerManagementObjectsSMOArgument = new UtilitySQLServerManagementObjectsSMOArgument
(
CheckBoxBackup.Checked,
database,
defaultName,
BackupDirectory,
MaintenanceDirectory,
ScriptDirectory,
CheckBoxMaintenance.Checked,
rule,
CheckBoxScript.Checked,
server,
SQLServerLoginUserName,
SQLServerPassword,
storedProcedure,
CheckBoxSystem.Checked,
table,
trigger,
CheckBoxUser.Checked,
userDefinedDataType,
userDefinedFunction,
view
);
UtilitySQLServerManagementObjectsSMO.UtilitySMO
(
ref UtilitySQLServerManagementObjectsSMOArgument,
ref exceptionMessage
);
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}//if ( exceptionMessage != null )
}//try
catch ( System.Exception exception )
{
exceptionMessage = exception.Message;
}
Feedback = exceptionMessage;
}//public void ButtonSubmit_Click()
