private void saveButton_Click(object sender, RoutedEventArgs e)
{
SQLInformation.Data.ApplicationDataSetTableAdapters.DBTablesTableAdapter ta = new SQLInformation.Data.ApplicationDataSetTableAdapters.DBTablesTableAdapter();
ta.Connection.ConnectionString = SQLInformation.Data.Config.SQLMonitorDBConnection;
ta.Update(Common.ApplicationDataSet.DBTables);
}
private void LoadTables(string instanceName, SQLInformation.Data.ApplicationDataSet.DatabasesRow databaseRow)
{
#if TRACE
//long startTicks = Common.WriteToDebugWindow(string.Format("Enter {0}:{1}()", TYPE_NAME, System.Reflection.MethodInfo.GetCurrentMethod().Name));
#endif
SMO.Server server = SMOH.SMOD.GetServer(instanceName);
SQLInformation.Data.ApplicationDataSetTableAdapters.DBTablesTableAdapter tableAdapter = new SQLInformation.Data.ApplicationDataSetTableAdapters.DBTablesTableAdapter();
tableAdapter.Connection.ConnectionString = SQLInformation.Data.Config.SQLMonitorDBConnection;
int dbID = databaseRow.ID_DB;
SMO.Database db = server.Databases.ItemById(dbID);
foreach (SMO.Table table in db.Tables)
{
SMOH.Table tableH = new SMOH.Table(table);
SQLInformation.Data.ApplicationDataSet.DBTablesRow newTable = Common.ApplicationDataSet.DBTables.NewDBTablesRow();
newTable.ID = Guid.NewGuid(); // See if this is available from table.
newTable.Name_Table = tableH.Name;
newTable.Table_ID = tableH.ID;
newTable.Database_ID = databaseRow.ID; // From above
newTable.Owner = tableH.Owner;
newTable.CreateDate = DateTime.Parse(tableH.CreateDate);
newTable.DataSpaceUsed = int.Parse(tableH.DataSpaceUsed);
try
{
newTable.DateLastModified = DateTime.Parse(tableH.DateLastModified);
}
catch (Exception ex)
{
}
newTable.RowCount = int.Parse(tableH.RowCount);
Common.ApplicationDataSet.DBTables.AddDBTablesRow(newTable);
tableAdapter.Update(Common.ApplicationDataSet.DBTables);
}
#if TRACE
//Common.WriteToDebugWindow(string.Format("Exit {0}:{1}()", TYPE_NAME, System.Reflection.MethodInfo.GetCurrentMethod().Name), startTicks);
#endif
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
SQLInformation.Data.ApplicationDataSet applicationDataSet = ((SQLInformation.Data.ApplicationDataSet)(this.FindResource("applicationDataSet")));
// Load data into the table Servers. You can modify this code as needed.
SQLInformation.Data.ApplicationDataSetTableAdapters.ServersTableAdapter applicationDataSetServersTableAdapter = new SQLInformation.Data.ApplicationDataSetTableAdapters.ServersTableAdapter();
applicationDataSetServersTableAdapter.Fill(applicationDataSet.Servers);
System.Windows.Data.CollectionViewSource serversViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("serversViewSource")));
serversViewSource.View.MoveCurrentToFirst();
// Load data into the table Instances. You can modify this code as needed.
SQLInformation.Data.ApplicationDataSetTableAdapters.InstancesTableAdapter applicationDataSetInstancesTableAdapter = new SQLInformation.Data.ApplicationDataSetTableAdapters.InstancesTableAdapter();
applicationDataSetInstancesTableAdapter.Fill(applicationDataSet.Instances);
System.Windows.Data.CollectionViewSource serversInstancesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("serversInstancesViewSource")));
serversInstancesViewSource.View.MoveCurrentToFirst();
// Load data into the table Databases. You can modify this code as needed.
SQLInformation.Data.ApplicationDataSetTableAdapters.DatabasesTableAdapter applicationDataSetDatabasesTableAdapter = new SQLInformation.Data.ApplicationDataSetTableAdapters.DatabasesTableAdapter();
applicationDataSetDatabasesTableAdapter.Fill(applicationDataSet.Databases);
System.Windows.Data.CollectionViewSource serversInstancesDatabasesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("serversInstancesDatabasesViewSource")));
serversInstancesDatabasesViewSource.View.MoveCurrentToFirst();
// Load data into the table DBTables. You can modify this code as needed.
SQLInformation.Data.ApplicationDataSetTableAdapters.DBTablesTableAdapter applicationDataSetDBTablesTableAdapter = new SQLInformation.Data.ApplicationDataSetTableAdapters.DBTablesTableAdapter();
applicationDataSetDBTablesTableAdapter.Fill(applicationDataSet.DBTables);
System.Windows.Data.CollectionViewSource serversInstancesDatabasesDBTablesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("serversInstancesDatabasesDBTablesViewSource")));
serversInstancesDatabasesDBTablesViewSource.View.MoveCurrentToFirst();
}
