public static void RecreateFolders() { StockDB.DeleteRows(StockDB.dtFolderAll, "ParentId = " + 2); DataRow[] rowArray1 = StockDB.GetDistinctRows(StockDB.dtSymbolList, "Exchange", "not Code like '^%'"); DataRow[] rowArray2 = rowArray1; for (int num1 = 0; num1 < rowArray2.Length; num1++) { DataRow row1 = rowArray2[num1]; StockDB.LoadFolderRow(2, row1["Exchange"].ToString(), false); } StockDB.ResetFolderDatabase(); StockDB.GetFolderDatatable(); }