private void CorrectStructuredMaterialDataBase () { WCFStandardsNS.WCFStandards DataBase = new WCFStandardsNS.WCFStandards (); DataSet MaterialTypenDataSet = DataBase.GetCommonDataSet ("Select TechnicalTyp from MaterialType"); DataTable MaterialTable = MaterialTypenDataSet.Tables ["MaterialType"]; DataSet FileIDsDataSet = DataBase.GetCommonDataSet ("Select Distinct FileID from " + "StructuredMaterialDataBase"); foreach (DataRow FileIDRow in FileIDsDataSet.Tables ["StructuredMaterialDataBase"].Rows) { DataSet EntriesForOneFileID = DataBase.GetCommonDataSet (String.Format ("Select * from StructuredMaterialDataBase where FileID = '{0}' order by FoldedArchivePath", FileIDRow ["FileID"].ToString ())); bool ErrorFound = false; List<String> FoldedNames = new List<string> (); List<String> FoundIDs = new List<string> (); foreach (DataRow MaterialRow in EntriesForOneFileID.Tables ["StructuredMaterialDataBase"].Rows) { String FoldedArchivePath = MaterialRow ["FoldedArchivePath"].ToString (); FoldedNames.Add (FoldedArchivePath); foreach (DataRow MaterialTypenRow in MaterialTable.Rows) { String Replacement = "_" + MaterialTypenRow [0].ToString ().ToUpper () + "_"; if (FoldedArchivePath.IndexOf (Replacement, StringComparison.InvariantCultureIgnoreCase) != -1) { ErrorFound = true; String NewSearchName = FoldedArchivePath.Replace (Replacement, ""); MaterialRow ["FoldedArchivePath"] = NewSearchName; } } } if (ErrorFound == true) { //MessageBox.Show ("Fehler bei ID\r\n" + FileIDRow ["FileID"].ToString () // + "\r\n" + String.Join ("\r\n", FoldedNames.ToArray())); DataBase.SetCommonDataSet (EntriesForOneFileID); } } }