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 }