private void btnLoadFromXML_Click(object sender, RoutedEventArgs e)
        {
            Test_Data.LKUPData.LoadLKUPInformationFromFile();

            foreach (var adDomain in Test_Data.LKUPData.ADDomains)
            {
                SQLInformation.Data.ApplicationDataSet.LKUP_ADDomainsRow newRow = Common.ApplicationDataSet.LKUP_ADDomains.NewLKUP_ADDomainsRow();
                newRow.ID           = adDomain.ID;
                newRow.ADDomainName = adDomain.Name;
                Common.ApplicationDataSet.LKUP_ADDomains.AddLKUP_ADDomainsRow(newRow);
            }

            Common.ApplicationDataSet.LU_ADDomainsTA.Update(Common.ApplicationDataSet.LKUP_ADDomains);

            foreach (var environment in Test_Data.LKUPData.Environments)
            {
                SQLInformation.Data.ApplicationDataSet.LKUP_EnvironmentsRow newRow = Common.ApplicationDataSet.LKUP_Environments.NewLKUP_EnvironmentsRow();
                newRow.ID = environment.ID;
                newRow.EnvironmentName = environment.Name;
                Common.ApplicationDataSet.LKUP_Environments.AddLKUP_EnvironmentsRow(newRow);
            }

            Common.ApplicationDataSet.LU_EnvironmentsTA.Update(Common.ApplicationDataSet.LKUP_Environments);

            foreach (var sqlVersion in Test_Data.LKUPData.SQLServerVersions)
            {
                SQLInformation.Data.ApplicationDataSet.LKUP_SQLServerVersionsRow newRow = Common.ApplicationDataSet.LKUP_SQLServerVersions.NewLKUP_SQLServerVersionsRow();
                newRow.ID       = sqlVersion.ID;
                newRow.Name     = sqlVersion.Name;
                newRow.CodeName = sqlVersion.CodeName;
                newRow.RTM      = sqlVersion.RTM;
                newRow.SP1      = sqlVersion.SP1;
                newRow.SP2      = sqlVersion.SP2;
                newRow.SP3      = sqlVersion.SP3;
                newRow.SP4      = sqlVersion.SP4;
                Common.ApplicationDataSet.LKUP_SQLServerVersions.AddLKUP_SQLServerVersionsRow(newRow);
            }

            Common.ApplicationDataSet.LU_SQLServerVersionsTA.Update(Common.ApplicationDataSet.LKUP_SQLServerVersions);
        }
        private void btnLoadFromXML_Click(object sender, RoutedEventArgs e)
        {
            // Read the data from the XML file.

            //Test_Data.InstanceData.LoadNewInstanceListFromFile();
            Test_Data.LKUPData.LoadNewListFromFile();

            foreach (var adDomain in Test_Data.LKUPData.ADDomains)
            {
                SQLInformation.Data.ApplicationDataSet.LKUP_ADDomainsRow newRow = Common.ApplicationDataSet.LKUP_ADDomains.NewLKUP_ADDomainsRow();
                newRow.ID           = adDomain.ID;
                newRow.ADDomainName = adDomain.Name;
                Common.ApplicationDataSet.LKUP_ADDomains.AddLKUP_ADDomainsRow(newRow);
            }

            foreach (var environment in Test_Data.LKUPData.Environments)
            {
                SQLInformation.Data.ApplicationDataSet.LKUP_EnvironmentsRow newRow = Common.ApplicationDataSet.LKUP_Environments.NewLKUP_EnvironmentsRow();
                newRow.ID = environment.ID;
                newRow.EnvironmentName = environment.Name;
                Common.ApplicationDataSet.LKUP_Environments.AddLKUP_EnvironmentsRow(newRow);
            }
        }