private void LoadDatabaseNames()
{
try
{
cbDatabaseName.Items.Clear();
using (SQLSentryDataStuff sn = new SQLSentryDataStuff())
{
DataTable dt = sn.GetSystemDatabases(ConnectionString);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
cbDatabaseName.Items.Add(row["Name"].ToString());
}
}
}
}
catch
{
throw;
}
}
private void LoadDatabaseObjects()
{
try
{
cbObjects.Items.Clear();
using (SQLSentryDataStuff sn = new SQLSentryDataStuff())
{
DataTable dt = sn.GetDatabaseObjects(ConnectionString, cbDatabaseName.Text, "10000");
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
cbObjects.Items.Add(row["Name"].ToString());
}
}
}
}
catch (Exception ex)
{
}
}
